#1
|
|||
|
|||
How to create mileage formula
I am trying to figure out a formula for mileage. Anything under 22 miles is $25.30 and anything over 22 miles is multiplied by $1.50 plus $25.30. How do you create a formula for this? |
#2
|
|||
|
|||
Quote:
/Møller |
#3
|
||||
|
||||
Just for the fun
=((A1-22)*1.5)*(A1>22))+25.30
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
That's quite elegant. It's requires a bit more than basic understanding but is elegant. I think it might be faster too if there are a lot of calculations of the type.
/Møller |
#5
|
||||
|
||||
I don't know about faster, it's just a bit more " back to basics". No knowledge of functions needed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create formula for entire column | tdodson | Excel | 2 | 10-27-2015 09:38 PM |
How to create vlookup formula range R1C1 using VBA | jyfuller | Excel Programming | 0 | 04-29-2015 12:03 PM |
Looking for formula that would create an average from certain criteria with in excel | bdouglas1011 | Excel Programming | 7 | 07-29-2014 08:16 AM |
How to create a formula using the IF in a time sheet. | spaul | Excel | 3 | 10-28-2013 07:19 PM |
Please help me create this formula... | doublejoy | Excel | 1 | 08-22-2009 03:04 AM |