| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
