SOLVED

IF AND IFS

%3CLINGO-SUB%20id%3D%22lingo-sub-3180681%22%20slang%3D%22en-US%22%3EIF%20AND%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180681%22%20slang%3D%22en-US%22%3E%3CP%3EBrain%20fog%20today...%20not%20sure%20why%20I'm%20struggling%20with%20this%20one...%20where%20is%20my%20mistake%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(X3%3D%22%22%2C%22%22)%2CIF(AC3%26lt%3B%26gt%3B%22%22%2CAC3-X3%2C%22%22)%2CIF(AND(X3%26lt%3B%26gt%3B%22%22%2CAC3%3D%22RELEASED%22)%2C%24AB%241-X3%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3180681%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3180876%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20AND%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1200123%22%20target%3D%22_blank%22%3E%40bfield66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(X3%3D%22%22%2C%20AC3%3D%22%22)%2C%20%22%22%2C%20IF(AC3%3D%22RELEASED%22%2C%20%24AB%241%2C%20AC3)-X3)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Brain fog today... not sure why I'm struggling with this one... where is my mistake?

 

=IF(X3="",""),IF(AC3<>"",AC3-X3,""),IF(AND(X3<>"",AC3="RELEASED"),$AB$1-X3,"")

1 Reply
best response confirmed by bfield66 (Occasional Contributor)
Solution

@bfield66 

 

=IF(OR(X3="", AC3=""), "", IF(AC3="RELEASED", $AB$1, AC3)-X3)