Can I do a Drop-Down for Calculating Mileage?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There
Need help ASAP--I am creating an expense report to be used company wide to calculate mileage. The thing is this report will be used in Canada as well...and the mileage rate is different. Is there a way on the expense report to have the US rate in the cell be a drop-down function to recalculate for the Canadian rate? Help

Thanks
 
Arimas,
If you've used a dropdown before, you'll know that you
can base other formulas off of its' answer. if US Mileage
is choice 1 and Canadian mileage is choice 2, then you
can do your calculations based on an if statement
=if(target cell=1,mileage@UScalc,if(target cell=2,mileage
at CDNcalc,"")
i can send you an example if you wish, e-mail me and
remove the NOSPAM. from my adress
HTH
Kevin M
-----Original Message-----
Hi There,
Need help ASAP--I am creating an expense report to be
Click to expand...
used company wide to calculate mileage. The thing is this
report will be used in Canada as well...and the mileage
rate is different. Is there a way on the expense report
to have the US rate in the cell be a drop-down function
to recalculate for the Canadian rate? Help!
 
Back
Top