Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help
I want to sum a cell that contains a formula with another cell that contains
a formula. How do I write a formula that will show the rersult? |
#2
|
|||
|
|||
Just add the 2 cells together.
Same as if they contained simple numeric data. =SUM(B2,B4) =B2+B4 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DEEKABEE" wrote in message ... I want to sum a cell that contains a formula with another cell that contains a formula. How do I write a formula that will show the rersult? |
#3
|
|||
|
|||
If the first cell containing a formula is A1 and the second is A2, one
way: =A1+A2 In article , "DEEKABEE" wrote: I want to sum a cell that contains a formula with another cell that contains a formula. How do I write a formula that will show the rersult? |
#4
|
|||
|
|||
It should be no different. Assuming your first cell w/ the formula is A1 and
the other B2... Then, in C3, you should be able to use =A1+B2 to get a sum regardless if A1 and B2 are formulas "DEEKABEE" wrote: I want to sum a cell that contains a formula with another cell that contains a formula. How do I write a formula that will show the rersult? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |