Can I do a Drop-Down for Calculating Mileage?

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
 
K

Kevin M

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overwriting a cell with a formula without deleting the formula 1
Mileage report for US and CAN rates .. help !! 1
Mod Formula for Mileage? 3
How do I set up a conditional cell from a drop down list in Excel 3
Setting up a worksheet 1
Muliplying a number by a blank cell 2
Small Pop Up Form to Calculate Mileage Reimbursement 3
formula connected to a dropdown list 8

Top