Forum Discussion
IF FUNCTION WITH MANY CONDITIONS RETURNING TO FALSE
I wanted my cell to show blank space but it always shows "false", please help!
This is my formula: =IF(I5<=K5,IF(O5="NO","REORDER"),IF(O5="YES",""))
1 Reply
This happens because the second IF statement does not have an ELSE condition (the third argument in IF), so it defaults to returning "FALSE" when its condition isn't met, please refer on below:
=IF(I5<=K5,IF(O5="NO","REORDER",IF(O5="YES","")),"")
