Previous Topic Next Topic

How to automatically input a word into one cell

Closed
Mike8989 - Updated on Feb 15, 2018 at 04:41 PM
 Blocked Profile - Feb 15, 2018 at 04:58 PM
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!



Related:

1 response

Answer 1 / 1
Blocked Profile
Updated on Feb 15, 2018 at 04:59 PM
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!

0

Similar discussions

Input phone lock code
Lucas -
M.Mudasir -

3 responses
phone lock <SOS>
keary88 -
Ambucias -

1 response
input phone password
djzombo -
Rahul -

2 responses
Forgotten input phone lock code
jared -
closeup22 -

1 response
Phone lock code
jax -
Ambucias -

1 response