Help with conditional formula

bpflyr

Board Regular
Joined
Nov 7, 2005
Messages
116
Can anyone help me do this. I am close, but just can't get it to work. The formula will go into cell AA.

If H3>0 AND J3>0 AND X3>0, then sum X3-Z3. If that calculation ='s 0 then "". If the calculation >0, then show that result.

Thank you in advance!
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

jimbojones

Well-known Member
Joined
Apr 22, 2002
Messages
776
Hi,

=IF(AND(H3>0,J3>0,X3>0),if(Sum(X3:Z3)<=0,"",Sum(X3:Z3))

Any help?

James
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
=IF(AND(H3>0, J3>0, X3>0), IF(SUM(X3:Z3)=0, "", SUM(X3:Z3)))

edit: didn't see jimbojones' post :)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,726
Messages
5,573,842
Members
412,553
Latest member
sfay
Top