Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I nest an OR function within an AND function?
Here is my example - can I do this? What have I done wrong I can't get it to
work. IF(AND(OR($AD4=A,$AD4=SU,$AD4=GF ),$AF4<),Updated Allowance is Not Applicable,"") |
#2
|
|||
|
|||
When I remove the "smart quotes" from your formula, it works as it
should. What does "I can't get it to work" mean? In article , "DebbieK" wrote: Here is my example - can I do this? What have I done wrong I can't get it to work. IF(AND(OR($AD4=A,$AD4=SU,$AD4=GF ),$AF4<),Updated Allowance is Not Applicable,"") |
#3
|
|||
|
|||
Debbie,
Your formula as shown: =IF(AND(OR($AD4="A",$AD4="SU",$AD4="GF"),$AF4<"") ,"Updated Allowance is Not Applicable","") worked fine for me. What logic do you want to actually use? HTH, Bernie MS Excel MVP "DebbieK" wrote in message ... Here is my example - can I do this? What have I done wrong I can't get it to work. IF(AND(OR($AD4="A",$AD4="SU",$AD4="GF"),$AF4<""), "Updated Allowance is Not Applicable","") |
#4
|
|||
|
|||
Your formula will check if AD4 is either "A", "SU" or "GF" AND AF4 is not blank
That can be simplified to =IF(AND(OR($AD4={"A","SU","GF"}),$AF4<""),"Update d Allowance is not Applicable","") Regards, Peo Sjoblom "DebbieK" wrote: Here is my example - can I do this? What have I done wrong I can't get it to work. IF(AND(OR($AD4=A,$AD4=SU,$AD4=GF ),$AF4<),Updated Allowance is Not Applicable,"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
how to move user defined function | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |