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!

How to automatically input a word into one cell
Transfer data from one excel worksheet to another automatically - Guide
Word free for u - Guide
Vim find word - Guide
How to input @ in laptop - Guide
Pc automatically restarts - Guide

1 reply

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!

Similar discussions

How to convert the Tamil Word doc to Tamil PDF?

How to convert the tamil pdf file to tamil word file

Excel - IF function with multiple words

Input phone lock code

Similar discussions

Subscribe To Our Newsletter!