Nested formulas

Copper Contributor

I'm having trouble getting all the fields on this worksheet to say "Yes" or "No" - two fields say FALSE.

How do I fix it

 

ReneeJoe201_0-1629215778680.png

 

2 Replies

@ReneeJoe201 That's because the two cells are exactly equal to 5. I.e. not greater than and not less then.

@ReneeJoe201 

Depends on what shall be for 5

=IF( F2 > 5, "Yes", "No" )