Hi. I am creating a spreadsheet for rental machines & need a formula to calculate if the hours used is less than or equal to 220, then multiply the hours used x $180. Then if the hours used is greater than 220, multiply 220 x $180 + hrs over 220, multiply $120 x additional hours. Any ideas on the formula to use? Thanks
Assuming your hours is in A1,
Formula:
Please Login or Register to view this content.
=if(a1>220,220*180+(a1-220)*120,a1*180)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Emmak153
Is this decimal time you are using or real time!
Time: A1
Formula:Please Login or Register to view this content.
Decimal Time: A1
Formula:Please Login or Register to view this content.
Wow. Thanks for your help! I forgot to mention if the hours used is less than 220, they will still be charged for 220 hrs. How would I calculate that? Thanks so much!
I think Sindhus answer meets that requirement, try that one
Last edited by dredwolf; 11-04-2012 at 07:40 PM.
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks