=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5

[Chad]

I enter this formula and I get a #value error.
=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S59),"XX", "
").

How do I get "XX" instead of having a number value.

 

[Dave Peterson]

What is in those two cells?

Maybe you can clean up those cells first if they contain errors.

 

[Luke M]

Your formula is correct in syntax. Do both cells S50 and S59 contain
TRUE/FALSE or 1/0 values? Another possible error is if your sheet names do
not actually have a space at beginning of name, but since you got the #VALUE
error, I'm leaning more toward you not having the correct types of logicals
in S50 and S59.

 

[Francis]

your formula is correct, it return XX if there are number in either one of the
cells, S50 or S59 and return #Value if nothing in there.

check that the cells contain real numbers, re-enter the number again or in a
unused column enter =ISTEXT(S50) and if it return TRUE, it is text.

If the cells contain real numbers, use this to return a blank if there are
no numbers
in both cells. Check if your Sheet name contain a space in front, if not
remove the space in front of the ' Job in the formula.

=IF(ISERROR(AND(' Job Duties Description'!S50,'Job Duties
Description'!S59)),"",IF(AND(' Job Duties Description'!S50,'Job Duties
Description'!S59),"XX",""))
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another