My formula is =IF(G3="x",E3)
If G3 is not "x" I'd like the cell to show nothing. It now shows "FALSE."
Gary
My formula is =IF(G3="x",E3)
If G3 is not "x" I'd like the cell to show nothing. It now shows "FALSE."
Gary
That's because you have omitted the third "value_if_false" argument from the IF() function. To get something other than FALSE, put the desired output into this argument. Recognize that Excel cannot return nothing, but most people use an invisible text string like a space character or empty string "". =IF(G3="x",E3,"")
Originally Posted by shg
Thanks. To have the cell return E3 only if it has a number of >0?
So, return E3 if G3 contains an "x" and if E3 is 1,2,3, etc., but if G3 contains an "x" but E3 is 0 then return a blank?
You understand how the IF() function works, so it is just a matter of combining the logic.
One way is to combine the "and" logic into a single condition using the AND() function =IF(AND(G3="x",E3>0),E3,"")
or nest IF() functions to test each condition separately. =IF(G3="x",IF(E3>0,E3,""),"")
From there you can build nested IF() functions as simple or as complex as you like. It's mostly about keeping track of the logic at each step.
This is very helpful. I appreciate it. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks