Excel formula help - possibly If(or) statement

I am needing a formula in Column G (Materials to Review).

If Column E indicates "False", Column G should read "review."
If Column F indicates "No Base", Column G should read "review."
If column E indicates "False" and F indicates "No base", column G should read "review.
If Column E and F is blank, Column G should be blank.

The formula below is what I currently have, but is not producing the results.

Please Login or Register  to view this content.

Perhaps

=IF(OR(E2=False,F2="No Base"),"review","")

=IF(AND(F2="",E2=""),"",IF(AND(F2="No Base",E2=FALSE),"Review",IF(OR(F2="No Base",E2=FALSE),"Review")))

if this helps click" * "

Originally Posted by Harribone

=IF(OR(E2="False",F2="No Base"),"Review","")

Your third statement is covered by the first two so this should do the job. Let me know if I've missed something.

I am not an expert but i think in above formula E2="False" will become False as "FASLE" is a Text and condition is logical

Formula with False not in quotations worked. Thanks

You're welcome.
Thanks for the feedback.

Originally Posted by mcranda

Formula with False not in quotations worked. Thanks

but how that one meet your fourth condition as E2=false will be treated as 0=false and answer will be true in that case if both cells are blank it will show review as answer not blank

Good point, however it did actually work in the file posted by the OP.
My guess is the cells in column E were formulas that returned either false or ""
And those formulas were then copy/pasted as values.
So the E2=False returned False

When I F2 and Enter on the cell, it then turns to True.


Anyway, to account for that..
=IF(OR(AND(ISLOGICAL(E2),E2=FALSE),F2="No Base"),"review","")


Also, OP was kind of ambiguouse by saying "The formula with False not in quotations"..
There were 2 suggested formulas that did that.

Hello Jonmo! This is the one ! Thanks for replying