multiply, then add
 

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

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

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

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

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