Yes formula

N

nela

Hi

I am not to good with formulas, I need a cell to be yes if the amount is
greater than 50.000. Can someone help on how to write the formula
Thanks.
 
M

Mike H

A single cell cannot be both >50 and yes but a cell can check another cell
for these conditions, For example you could have this in A2 checking A1

=if(A1>50.000,"Yes","No")

Mike
 
V

Vergel Adriano

Nela,

Put 50.001 in A1. Then in B1 enter this formula:

=IF(A1>50.000, "Yes", "No")
 
H

Huber57

If you want to substitute Yes for modifying the appearance of the cell
(changing the text color, background color, etc):

Go to Format | Conditional Formatting

Then select "Cell Value Is" and "Greater Than" and then enter 50 in the 3rd
box.

Next, click Format... and select how you want the cell to appear when the
value is greater than 50.

Hope that helps.
 
Top