| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
or < Than
Please Help
I'm Trying to do a mileage counter and I need to know the formula for cell b57 if the first 10000 miles are charged at 40p and every mile after that at 25p. B57 is the counting cell for how many miles per week I do. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
or < Than
=MIN(B57,10000)*0.4 + MAX(B57-10000,0)*0.25
should do it (gives the answer in £) Kev wrote: Please Help I'm Trying to do a mileage counter and I need to know the formula for cell b57 if the first 10000 miles are charged at 40p and every mile after thatat 25p. B57 is the counting cell for how many miles per week I do. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
or < Than
If I'm understanding you issue correctly, try this:
=IF(B57<=10000,B57*0.4,B57*0.4+(B75-10000)*0.25) -- ERR229 "Kev" wrote: Please Help I'm Trying to do a mileage counter and I need to know the formula for cell b57 if the first 10000 miles are charged at 40p and every mile after that at 25p. B57 is the counting cell for how many miles per week I do. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
