Excel false

%3CLINGO-SUB%20id%3D%22lingo-sub-1433490%22%20slang%3D%22en-US%22%3EExcel%20false%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433490%22%20slang%3D%22en-US%22%3E%3CP%3EFrustrated%20on%20this%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3DIF((%24B12%3D%22management%22)%2CIF(%24R12%3D%22lodge%20only%22%2C(%24P12*%24AN%243)%2CIF(%24R12%3D%22travel%22%2CIFNA(VLOOKUP(%24K12%2C'Accounts%20Rates'!%24A%243%3A%24K%2454%2CMATCH(%24R12%2C'Accounts%20Rates'!%24A%242%3A%24K%242%2C0)%2CFALSE)%2C%220%22)*(%24O12*%24AN%242*2)%2CIF(%24R12%3D%22lodge%22%2C(%24AN%243*%24O12)*%24M12))%2B(IFNA(VLOOKUP(%24K12%2C'Accounts%20Rates'!%24A%243%3A%24K%2454%2CMATCH(%24Q12%2C'Accounts%20Rates'!%24A%242%3A%24K%242%2C0)%2CFALSE)%2C%220%22)*%24P12)))%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EObviously%20gives%20a%20%22false%22%20result%20in%20the%20cell%20and%20have%20tried%20every%20configuration%2C%20but%20this%20gives%20me%20the%20result%20I%20need%20when%20the%20correct%20inputs%20in%20the%20referenced%20cells%20are%20utilised.%20However%2C%20have%20a%20sum%20that%20is%20reliant%20to%20this%20cell%20answer%20and%20as%20has%20%22false%22%20in%20it%20then%20gives%20%23valve%20response.%20What%20am%20I%20missing%20as%20believe%20used%20the%20precursor's%20iferror%20etc.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433490%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Frustrated on this one.

 

=IF(($B12="management"),IF($R12="lodge only",($P12*$AN$3),IF($R12="travel",IFNA(VLOOKUP($K12,'Accounts Rates'!$A$3:$K$54,MATCH($R12,'Accounts Rates'!$A$2:$K$2,0),FALSE),"0")*($O12*$AN$2*2),IF($R12="lodge",($AN$3*$O12)*$M12))+(IFNA(VLOOKUP($K12,'Accounts Rates'!$A$3:$K$54,MATCH($Q12,'Accounts Rates'!$A$2:$K$2,0),FALSE),"0")*$P12)))

 

Obviously gives a "false" result in the cell and have tried every configuration, but this gives me the result I need when the correct inputs in the referenced cells are utilised. However, have a sum that is reliant to this cell answer and as has "false" in it then gives #valve response. What am I missing as believe used the precursor's iferror etc.

0 Replies