#VALUE! Error

Brass 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))),"")