| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiplying cells and adding that answer in the same cell
Hi,
I am sure this is a very simple formula, but for some reason I cant seem to get it today. I am trying to Multiply cell C22 by B21 and have the results added to C22 all in one cell and I can't seem to get it right. Please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiplying cells and adding that answer in the same cell
You would need to use VBA for that unless you mean that in a third cell (not
C22) you want to add C22 to C22xB21? If so use =(C22*B21)+C22 you cannot however use that formula in C22 since it will create a circular reference, so you need a macro that will do this -- Regards, Peo Sjoblom "Michele" wrote in message ... Hi, I am sure this is a very simple formula, but for some reason I cant seem to get it today. I am trying to Multiply cell C22 by B21 and have the results added to C22 all in one cell and I can't seem to get it right. Please help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiplying cells and adding that answer in the same cell
If you want the answer in cell A1 then the formula in cell A1 is
=C22*B21+C22. If you want the value to be in C22, it is a circular reference. Understand that Excel recalculates the formulas. After the first evaluation of C22, what do you get the second time? It goes round and round. In addition, if the result of the calculation goes in C22, what happens to the formula in C22? Tyro "Michele" wrote in message ... Hi, I am sure this is a very simple formula, but for some reason I cant seem to get it today. I am trying to Multiply cell C22 by B21 and have the results added to C22 all in one cell and I can't seem to get it right. Please help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiplying cells and adding that answer in the same cell
=C22*B21+C22
"Michele" wrote: Hi, I am sure this is a very simple formula, but for some reason I cant seem to get it today. I am trying to Multiply cell C22 by B21 and have the results added to C22 all in one cell and I can't seem to get it right. Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for multiplying and adding percentage please help. | New Users to Excel | |||
| Multiplying non consecutive rows, than adding it. | Excel Discussion (Misc queries) | |||
| Multiplying non consecutive rows, then adding it. | Excel Worksheet Functions | |||
| Sumproduct multiplying instead of adding | Excel Worksheet Functions | |||
| multiplying the same cell by different cells and copying formula | Excel Worksheet Functions | |||
Linear Mode
