Apr 12 2022 10:47 AM
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)))
Apr 12 2022 10:56 AM - edited Apr 12 2022 10:57 AM
@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))),"")