Aug 08 2021 02:10 PM
I'm trying to do VLookup with an IF and ISNA statement combined so that the VLookup searches the table and multiplies I16 by the appropriate penalty in the penalty schedule box. But if I16 is negative (like in this case), instead of saying #N/A, it would be a dash for zero. I've been able to create separate formulas but cannot figure out how to join them together.
Aug 08 2021 02:19 PM
SolutionAug 08 2021 02:19 PM
Solution