How to automatically input a word into one cell

Mike8989 - Updated on Feb 15, 2018 at 04:41 PM
 Blocked Profile - Feb 15, 2018 at 04:58 PM

I’m having a hard time trying to figure out how to automatically input a certain word into one cell if a different cell is less than another cell.


I want C1 to say “YES” if B1 is less than A1.

Any help please??
Thanks in advance!

1 reply

In the cell you wish to display Yes, place the following:


The syntax for IF is as follows:

=IF(logic_test, true ,false)

Have FUN!