Excel nested IF statement

Question

=If(ISBLANK(F3),IF(F3<E3, ʺYesʺ, ʺNoʺ))

Have tried many iterations of this code to reach two outcomes on a stock order sheet.

Result should return If Blank or cell difference is equal or greater than as "Yes" and "No" if smaller than.

Any help is appreciated.

@Forwarded I'd be surprised if it were, too. But I've been surprised in the past :-) — Ron Rosenfeld
– Ron Rosenfeld, Commented May 31, 2016 at 12:28

David · Accepted Answer · 2016-05-31 10:58:46Z

2

Check your quotes. Excel uses simple quotes " not ʺ.

=If(ISBLANK(F3),IF(F3<E3, "Yes", "No"))

answered May 31, 2016 at 10:58

David

14411 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Forward Ed · Accepted Answer · 2016-05-31 12:09:31Z

0

Instead of using ISBLANK(), use the following:

=IF(OR(F3="",F3>=E3),"No","Yes")

You have two options there as your question was not clear as to which cell was to be greater than or equal which.

The reason you want to use the F3="" instead of ISBLANK(F3), is that if you have a formula in F3 that returns "" as a result, that is not the same as a blank cell. If you want to be safer, you may want to consider wrapping the first F3 in a CLEAN(TRIM(F3)) to remove when someone may have entered a space in the cell.

edited May 31, 2016 at 12:09

answered May 31, 2016 at 11:06

Forward Ed

9,9843 gold badges29 silver badges57 bronze badges

5 Comments

Shaun Hobbs Over a year ago

Base Stock Level Quantity in Stock Need to order Quantity to order are the headings so basically if the quantity in stock is less than the base stock level the need to order cell should read yes or no and also no if the cell is empty.

Forward Ed Over a year ago

So when you have a value in E and a Value in F, does E need to be less than F or does F need to be less than E for no to display?

Shaun Hobbs Over a year ago

E needs to be less than or equal to F

Forward Ed Over a year ago

Formula has been updated. If you look at the OR( , ) there is a logical check before and after the coma. If either of those logical checks is TRUE, then the whole OR() is equal to TRUE. And when the OR is TRUE, then you get a NO.

Shaun Hobbs Over a year ago

Thank you so much! Lifesaver!

Brian · Accepted Answer · 2016-05-31 13:38:26Z

0

Maybe this:

=IF(OR(ISBLANK(F13),F13<E13),"No","Yes")

edited May 31, 2016 at 13:38

answered May 31, 2016 at 12:10

Brian

2,1182 gold badges17 silver badges30 bronze badges

Collectives™ on Stack Overflow

Excel nested IF statement

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related