If+or+and

[firstWeMeet]

G11 = 3
R11 = 4

S11=IF(OR(G11="",R11>G11),"",G11-R11) then its still blank, what I wanted is to be negative - 1 can anyone correct my formula in S11?
Thanks

 

[Hermanito]

Make it to be:
S11=IF(OR(G11="",R11>G11),G11-R11,"")

the first option is what you want to appear if the condition is true, the second for when it's false.

 

[firstWeMeet]

There is an error since my R11 & G11 has a if statement also.

 

[Hermanito]

please give the full setup of your sheet, with formula's, and what you want to achieve...

 

[Aladin Akyurek]

G11 = 3
R11 = 4

S11=IF(OR(G11="",R11>G11),"",G11-R11) then its still blank, what I wanted is to be negative - 1 can anyone correct my formula in S11?
Thanks

Is this...

=IF(COUNT(G11,R11)=2,G11-R11,"")

perhaps what you are after?

 

[firstWeMeet]

G11 = IF(Total_Qty1=0,"",Total_Qty1)
R11 = IF(SUM(H11:Q11)=0,"",SUM(H11:Q11))
S11 = IF(OR(G11="",R11>G11),G11-R11,"") as what you revised.

then at the row 12 G11 = Total_Qty2 is 0 so that the cell G11=""
same with the R11 = "" since the H12:Q12 = 0
then I got #VALUE! in S12

 

[Michael M]

The only way you'll get -1 with you current data is

=IF(OR(G11="",R11 < G11),"",G11-R11)

 

[firstWeMeet]

Is this...

=IF(COUNT(G11,R11)=2,G11-R11,"")

perhaps what you are after?

Thanks, this is working.

 

[Michael M]

Glad you got it sorted.....nice one Aladin....a bit Psychic...LOL !!

 

[Aladin Akyurek]

Thanks, this is working.

Glad you got it sorted.....nice one Aladin....a bit Psychic...LOL !!

Thank you. I appreciate the feedback.