Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5
What is in those two cells?
Maybe you can clean up those cells first if they contain errors. Chad wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Chad" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5
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 "Chad" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COMPLETE DESCRIPTION | Excel Discussion (Misc queries) | |||
max in on column, description in another | Excel Worksheet Functions | |||
Put help/description in formulas (XLA) | Excel Discussion (Misc queries) | |||
Parameter description | Excel Worksheet Functions | |||
Description box in excel | Excel Discussion (Misc queries) |