SOLVED

IF/AND Formula Not Working

%3CLINGO-SUB%20id%3D%22lingo-sub-2944316%22%20slang%3D%22en-US%22%3EIF%2FAND%20Formula%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2944316%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20formulate%20a%20column%20that%20will%20return%20a%20DAYS%20formula%20result%20if%20multiple%20conditions%20are%20met%2C%20or%20a%20blank%20cell%20if%20they%20are%20not.%20Whatever%20I%20do%2C%20though%2C%20is%20returning%20a%20blank%20value.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20that%20I%20am%20using%20in%20Column%20K%20is%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(AND(%5B%40%5BPuchasing%20Agent%5D%5D%3D%22%26lt%3B%26gt%3B%22%2C%5B%40GL%5D%3D%220%22)%2CDAYS(TODAY()%2C%5B%40%5BP.O.%20Release%5D%5D)%2C%22%22)%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20should%20receive%20a%20numerical%20value%20if%20true%2C%20or%20a%20blank%20return%20if%20false.%20All%20I%20am%20getting%20is%20false%20values%20though.%20What%20am%20I%20doing%20wrong%3F%20Does%20it%20matter%20that%20the%26nbsp%3B%40GL%20column%20is%20a%20formula%20rather%20than%20a%20number%3F%20If%20so%2C%20I%20haven't%20had%20this%20issue%20when%20using%20similar%20calculations.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-11-09%20133420.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325638i1B84464861757D20%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-11-09%20133420.jpg%22%20alt%3D%22Screenshot%202021-11-09%20133420.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2944316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2944337%22%20slang%3D%22en-US%22%3ERe%3A%20IF%2FAND%20Formula%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2944337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1213069%22%20target%3D%22_blank%22%3E%40Edg38426%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%5BGL%5D%20column%20contains%20numbers%2C%20not%20texts.%20Perhaps%20you%20mean%26nbsp%3B%3CSTRONG%3E%22%26lt%3B%26gt%3B%22%2C%5B%40GL%5D%3D0%20%3C%2FSTRONG%3E(not%26nbsp%3B%22%26lt%3B%26gt%3B%22%2C%5B%40GL%5D%3D%220%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am trying to formulate a column that will return a DAYS formula result if multiple conditions are met, or a blank cell if they are not. Whatever I do, though, is returning a blank value. 

 

The formula that I am using in Column K is

=IF(AND([@[Puchasing Agent]]="<>",[@GL]="0"),DAYS(TODAY(),[@[P.O. Release]]),"") 

 

I should receive a numerical value if true, or a blank return if false. All I am getting is false values though. What am I doing wrong? Does it matter that the @GL column is a formula rather than a number? If so, I haven't had this issue when using similar calculations. 

 

Screenshot 2021-11-09 133420.jpg

 

6 Replies

@Edg38426 

[GL] column contains numbers, not texts. Perhaps you mean "<>",[@GL]=0 (not "<>",[@GL]="0")

Thank you for replying. I just tried changing it per your suggestion, but it did not affect the return value.
My intent here is this: If there is data in the Purchasing Agent field (meaning that it has been assigned to said agent) AND there is not a GL entry yet (currently being calculated using a COUNTIF formula which references another worksheet in this same workbook), then I need to be able to see the number of days that have passed since the Agent has released the job (days from P.O. Release field). Is there perhaps an easier way to do this?
best response confirmed by Edg38426 (Occasional Contributor)
Solution

@Edg38426 

I miss nonblank checking. It'll be

=IF(AND([@[Puchasing Agent]] <>"",[@GL]=0),TODAY()-[@[P.O. Release]],"")

image.png

That worked perfectly. Thank you so much for your help! 

@Edg38426 , you are welcome, glad to help