=IF('Quarterly Data'!C351> Goals!$Q$45,0,(IF('Quarterly Data'!C395=0,"N/A",(IF((('Quarterly Data'!C351/Goals!$Q$45)-1)=(-1),(100),(ABS(('Quarterly Data'!C351/Goals!$Q$45)-1))*100)))))
Could someone tell me what the -1, (100) is?
So when I calculate the formula (131.511 / 206.076653) I get .6381 then when I take that number and -1 I get 0.3618 *100 for 36.18
Why do we -1? why wouldn't you take .6381*100 for 63.81?
I am just trying to understand why it was written like this so I can verify numbers in a spreadsheet.
Could someone tell me what the -1, (100) is?
So when I calculate the formula (131.511 / 206.076653) I get .6381 then when I take that number and -1 I get 0.3618 *100 for 36.18
Why do we -1? why wouldn't you take .6381*100 for 63.81?
I am just trying to understand why it was written like this so I can verify numbers in a spreadsheet.