For cell H2, =IF(AND($F$2>0,G2=0),"N/A",(($G$2-$F$2)/$G$2)) works fine when F2>0 and G2=0, and shows correct percentage difference between the two when values for both cells are entered.
However, if I copy that formula down the column, I get #DIV/0!.
I've tried adding another IF statement whe3n F2 is blank, but I keep getting error messages.
What can I add to this formula to return a blank cell H2 if F2 is blank?
Thanks
However, if I copy that formula down the column, I get #DIV/0!.
I've tried adding another IF statement whe3n F2 is blank, but I keep getting error messages.
What can I add to this formula to return a blank cell H2 if F2 is blank?
Thanks