View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default multiply, then add

Try this

=SUM(A1*0.029,A1,0.3)

"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