View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default multiply, then add

Brenna, to get your answer with 25 in A1 try this, =(A1*0.029)+0.3+A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"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