Rab WOT? Moderating Team 10,981 Member For: 11y 9m 6d Gender: Male Location: Frankston, 3199 Posted 30/04/14 08:29 AM Share Posted 30/04/14 08:29 AM http://www.instructables.com/id/Using-Excels-Basic-Formula-Functions-to-Create-an-/step7/Calculating-Area-Cost/ 1 Link to comment Share on other sites More sharing options...
Dagabond Bored Member Administrator 35,722 Member For: 22y 17d Gender: Male Location: Dé·jà vu Posted 30/04/14 08:51 AM Share Posted 30/04/14 08:51 AM Thats a simple sum I'm after something that'll cut out the middle man....ie me.. Link to comment Share on other sites More sharing options...
k31th less WHY; more WOT Site Developer 29,005 Member For: 16y 7m 21d Gender: Male Location: Melbourne Posted 30/04/14 08:52 AM Share Posted 30/04/14 08:52 AM legitimate request? Link to comment Share on other sites More sharing options...
Dagabond Bored Member Administrator 35,722 Member For: 22y 17d Gender: Male Location: Dé·jà vu Posted 30/04/14 08:58 AM Share Posted 30/04/14 08:58 AM Half assed. Link to comment Share on other sites More sharing options...
Rab WOT? Moderating Team 10,981 Member For: 11y 9m 6d Gender: Male Location: Frankston, 3199 Posted 30/04/14 09:01 AM Share Posted 30/04/14 09:01 AM (edited) LxWxC($/sq.m)=$?edit: not sure what you're asking4 cells, A1, A2, A3 and A4A1 is LengthA2 is WidthA3 is priceA4 is total costA4 formula is =A1*A2*A3 Edited 30/04/14 09:05 AM by raband Link to comment Share on other sites More sharing options...
Never had any say Panda I <3 Floods Silver Donating Members 11,198 Member For: 13y 4m Gender: Male Location: South West QLD Posted 30/04/14 09:52 AM Share Posted 30/04/14 09:52 AM Yeah that sounds simple dags..But raband got it.. I could add a few if queries in and colour code the cell based on end dollar figure if you want..Apply escalation factors based on amount of steel ordered? Ie small order has a higher cost per square, bigger order lower cost? Link to comment Share on other sites More sharing options...
Rab WOT? Moderating Team 10,981 Member For: 11y 9m 6d Gender: Male Location: Frankston, 3199 Posted 30/04/14 11:06 AM Share Posted 30/04/14 11:06 AM Really should be done in MS Access - separate table for each field, buttons and a swish front end 1 Link to comment Share on other sites More sharing options...
ms700 Moderating Team 10,170 Member For: 21y 10m Gender: Male Location: Sydney Posted 30/04/14 11:24 AM Share Posted 30/04/14 11:24 AM nah shouldnt be done in mscauselazy Link to comment Share on other sites More sharing options...
Dagabond Bored Member Administrator 35,722 Member For: 22y 17d Gender: Male Location: Dé·jà vu Posted 30/04/14 11:28 AM Share Posted 30/04/14 11:28 AM ^^The one above that sounds along the lines that I'm lookin for but ^this sounds more accurate and stuff. Link to comment Share on other sites More sharing options...
Rab WOT? Moderating Team 10,981 Member For: 11y 9m 6d Gender: Male Location: Frankston, 3199 Posted 30/04/14 11:48 AM Share Posted 30/04/14 11:48 AM You want a basic App that has 2 questions?Width and length?Then it gives you the answer based on the cost?Try this? https://docs.google.com/spreadsheets/d/14JJpsubPPa5_aQGWBHXIPEE_bBaRGOhTnExx-92fASk/edit?usp=sharing Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now