Hi All,
I am getting an error when i calculate 2 cell. Depending on the values its working with i get either #Num! or #Div/0!, Is there anyway to correct this within the calculation to just return zero?
My Calculation is JTD: [RevSpendtoDate]/[SpendtoDate] so below are the values that cause it:
0/0 = #Num!
144/0 = #Div/0!
I understand why I'm getting it and that it is correct based on what I'm trying to do but i need 0 to be the result instead of the #num and div
Appreciate any help possible
Treacy