How to automatically input a word into one cell [Closed]

Report
-
 Blocked Profile -
Hello,

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.

Example

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:

=If(a1>b1,"Yes","NO")

The syntax for IF is as follows:

=IF(logic_test, true ,false)

Have FUN!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!