Forum Discussion
milage rates for a travel expense form
Hi is it possible to choose a different milage rate in one cell? example: the standard is set at miles x .40p = but if you had an addition passenger it would be miles x .42p ( additional .2p an...
You can't "hover over a cell and choose" per se but you can have a column called rate or # of people and then the calculation in the total cell can take that into account.
For example you have:
miles . . . . . # people . . . . . $$
195 . . . . . . . . . 3 . . . . . . . . . = A2 * (0.40+IF(B2>1,B2,0)/100)
and that formula will add 2,3,... cents to the 0.40 if there are more than 1 people in the car and then multiple by the miles for the total rate.
EDIT: as noted by SnowMan55 I removed the -1 inside the IF statement. (I have no idea why I put that there because I knew it shouldn't be.)