multiply, then add
In cell B1 write this formula :
=A1*0.029+3
If you have $25 in A1 then B1 will be $3.725 not $26.025
Then you can paste in B column as needed. HIH.
"brenna" wrote:
I am trying to write a function that will multiply numberin column A by 0.029
and then add .3 to it. I know this must be really elementary... In other
words, if column A has $25 then column B should have $26.025
--
Thanks!
Brenna
|