multiply, then add
Your problem is that 25 x 0.029 + 0.3 does not equal $26.025, it equals $1.025.
If you want to add the original $25 to the result, you will get the $26.025. If
so, your formula becomes:
=a1*1.029+0.3
--
Regards,
Fred
"brenna" wrote in message
...
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
|