Forum Discussion
Tricky 3-Part Formula
Tricky for me! Aircraft flight time invoice. I need to calculate monthly totals based on the following: ~First 5 hours (0.1 - 5.0) at $2000/hr. ~Next 5 hours (5.1 - 10) at $2500/hr ~Over 10 hour...
Try using the If Formula2 Example (See attached file for reference):
| =IF(B2<=5,B2*2000,IF(B2<=10,10000+(B2-5)*2500,22500+(B2-10)*3000)) |
Matt,
That works PERFECTLY, and will make my life much easier!
I can't thank you enough!
All the best,
Dan
Daniel-
Glad to help out. Feel free to post back to the community if you need additional assistance!
