How to automatically input a word into one cell Closed

Question

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!



System Configuration: iPhone / Safari 11.0

ac3mark · Answer

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!

How to automatically input a word into one cell

1 response

Similar discussions

Subscribe To Our Newsletter!