ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/251562-formula.html)

CCSOLinda

Formula

I would like to be able to enter mileage in a cell and have it show up how
much $ it is based on .59 per mile. Is there a way to do this without having
to add a column?

Eduardo

Formula

Hi,
Let' say you enter the milage in cell A1 in B1 enter the formula as follow

=a1*0.59

if this helps please click yes thanks

"CCSOLinda" wrote:

I would like to be able to enter mileage in a cell and have it show up how
much $ it is based on .59 per mile. Is there a way to do this without having
to add a column?

All times are GMT +1. The time now is 12:40 AM.