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?

I believe this is what you are looking for
IF(And(A1x, B1x), result)

Lorne
Wilhelm wrote:
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?

Wilhelm wrote:
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?


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