IF functions

W

Wilhelm

I can't seem to figure out how to form an IF function that takes into account
values from more than one cell. E.g. is it possible to form an IF function
which checks if the values in cells A1 and B1 are big enough and returns the
value TRUE only if BOTH cells contain the correct value?
 
F

Franz Verga

Wilhelm said:
I can't seem to figure out how to form an IF function that takes into
account values from more than one cell. E.g. is it possible to form
an IF function which checks if the values in cells A1 and B1 are big
enough and returns the value TRUE only if BOTH cells contain the
correct value?
Click to expand...


Hi Wilhelm,

without any data... Try something like this:

IF(AND(A1>=5,B1>=6),"True","False")


Check on line help for AND and OR functions.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top