Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
how to multiply two columns | New Users to Excel | |||
Multiply all values by 10 | Excel Discussion (Misc queries) | |||
multiply | Excel Worksheet Functions | |||
multiply negatives | Excel Discussion (Misc queries) |