Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text in formula bar is not displaying in cell Mike Excel Discussion (Misc queries) 0 August 29th 05 09:47 PM
How do I make a formula that uses the fist cell as a starting posi mrbshansen Excel Discussion (Misc queries) 1 April 18th 05 03:48 PM
put formula results into a different cell if it is empty PutFormula Excel Worksheet Functions 2 February 11th 05 04:31 AM
Can a Formula in Cell X modify Cell Y? alMandragor Excel Discussion (Misc queries) 7 February 10th 05 10:51 PM
Cell shows formula and not the result of the formula. stumpy1220 Excel Worksheet Functions 2 January 14th 05 06:11 PM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"