Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Trying to make multiple formula cell
I have 4 cells, A3,B3,C3, and D3.
=IF(OR(A3="",B3="",C3=""),"",A3+B3+C3) (for when D3 is absent) =IF(OR(A3="",C3="",D3=""),"",A3-C3-D3) (for when B3 is absent) How can I combine these two formulas into one cell? Like if I did not put a value for B3, but did put a value for D3, the second formula's answer would come out and if I did put a value for B3 and not for D3, the first formula's answer would pop out of the same cell. Help~ |
#2
|
|||
|
|||
Hi
=IF(AND(B3<"",D3=""),SUM(A3:C3),IF(B3="",D3<"",S UM(A3,-(C3:D3)),"")) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) wrote in message oups.com... I have 4 cells, A3,B3,C3, and D3. =IF(OR(A3="",B3="",C3=""),"",A3+B3+C3) (for when D3 is absent) =IF(OR(A3="",C3="",D3=""),"",A3-C3-D3) (for when B3 is absent) How can I combine these two formulas into one cell? Like if I did not put a value for B3, but did put a value for D3, the second formula's answer would come out and if I did put a value for B3 and not for D3, the first formula's answer would pop out of the same cell. Help~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
How do I make a formula that uses the fist cell as a starting posi | Excel Discussion (Misc queries) | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |