Multiple IF Statement - Where am I going wrong?!

[tlc53]

Hi there,

Can anyone tell me why the following IF statement is not working? Regardless of the values in cells G51 and H51 (which are formulated) the IF statement result doesn't change from "Total Under Claimed".

=IF(G51>0,"Total Under Claimed",IF(H51>0,"Total Over Claimed",""))

Thank you!

 

[tlc53]

Lovely, thank you so much!!
I think I get the hang of it now and I can see it's going to come in very handy. Thanks for the tip and your help!

 

[jtakw]

You're welcome, thanks for the feedback.

Post back if you need additional assistance.

 

[krobin350]

I am currently running into a similar issue as the OP. New to the forum, apologies if a new thread is required.

Attempting to return the value of 1 of 3 prioritized cells... A1 (which contains "" within the formula), B1 and C1.
Whereas I would only want the value of C1 returned IF B1 and A1 are blank. And would only want B1 IF A1 is blank.
This is my current formula:
=IF(A1>0,IF(B1>0,B1,IF(C1>0,C1,A1)))

It works when value present in B1 and/or C1, but once A1 populates it still returns B1.
Please advise what I could be missing here