Forum Discussion
Solved
How to calculate the percentage difference between values in a row by skipping blanks
Hello all, I am using Excel on a PC, version 2302 build 16.0.16130.20332. I am looking for a formula to help me calculate the percentage difference of quantities between months. The problem is, there...
In N29:
=IF(C29="", "", IFERROR(C29/LOOKUP(9.99999999999999E+307,$B29:B29)-1, 0))
Format as a percentage, then fill to the right to V29, and fill down as far as you want.
In N29:
=IF(C29="", "", IFERROR(C29/LOOKUP(9.99999999999999E+307,$B29:B29)-1, 0))
Format as a percentage, then fill to the right to V29, and fill down as far as you want.