#VALUE! Error

%3CLINGO-SUB%20id%3D%22lingo-sub-3283517%22%20slang%3D%22en-US%22%3E%23VALUE!%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283517%22%20slang%3D%22en-US%22%3E%3CP%3EListed%20below%20is%20the%20formula%20I%20am%20using.%26nbsp%3B%20When%20cells%20are%20populated%2C%20the%20solution%20is%20correct.%26nbsp%3B%20If%20cells%20are%20not%20populated%20there%20are%20several%20cells%20that%20will%20read%20%23VALUE!%2C%20this%20looks%20very%20unprofessional.%26nbsp%3B%20How%20would%20I%20enter%20an%20IFERROR%20into%20the%20current%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF((F21%26lt%3B%3D2500)%2C(VLOOKUP(C21%2C%24E%2485%3A%24L%24200%2C6%2CFALSE))%2C((F21-2500)*(VLOOKUP(C21%2C%24E%2485%3A%24L%24200%2C5%2CFALSE)))%2B(VLOOKUP(C21%2C%24E%2485%3A%24L%24200%2C6%2CFALSE)))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3283517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283536%22%20slang%3D%22en-US%22%3ERe%3A%20%23VALUE!%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1361076%22%20target%3D%22_blank%22%3E%40erin-5304%3C%2FA%3E%26nbsp%3BUnable%20to%20test%2C%20but%20when%20you%20say%20the%20formula%20works%20with%20values%2C%20try%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIFERROR(IF((F21%26lt%3B%3D2500)%2C(VLOOKUP(C21%2C%24E%2485%3A%24L%24200%2C6%2CFALSE))%2C((F21-2500)*(VLOOKUP(C21%2C%24E%2485%3A%24L%24200%2C5%2CFALSE)))%2B(VLOOKUP(C21%2C%24E%2485%3A%24L%24200%2C6%2CFALSE)))%2C%22%22)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Listed below is the formula I am using.  When cells are populated, the solution is correct.  If cells are not populated there are several cells that will read #VALUE!, this looks very unprofessional.  How would I enter an IFERROR into the current formula?

 

 

=IF((F21<=2500),(VLOOKUP(C21,$E$85:$L$200,6,FALSE)),((F21-2500)*(VLOOKUP(C21,$E$85:$L$200,5,FALSE)))+(VLOOKUP(C21,$E$85:$L$200,6,FALSE)))

1 Reply

@erin-5304 Unable to test, but when you say the formula works with values, try this:

 

=IFERROR(IF((F21<=2500),(VLOOKUP(C21,$E$85:$L$200,6,FALSE)),((F21-2500)*(VLOOKUP(C21,$E$85:$L$200,5,FALSE)))+(VLOOKUP(C21,$E$85:$L$200,6,FALSE))),"")