I have numeric values in L34, L35, L36, L37 & L38.
Which generate values in P34...P37, unless L38, L37, etc. is -0-, then N/A is generated. This works.
But, In R34...R37, the values of P34...P37 are used for calculation. When the divisor is N/A, obviously I am getting an error. I want to generate another N/A in the R series cells when the divisor is N/A.
T34..T38 generate %'s based on the values of L34...L38, with L38 being the base year (divisor). When L38 is -0-, I want the base year to be L37 and on up.
I have attached a small portion of the spreadsheet with the exact formulas.