how to calcualte the % variance between 2 negative numbers

[kay]

Can anyone help with a formular on how to calculate the % variance between 2 negative numbers?

I have in column f4 -2.241 and -2.888 in colum g4.

Can anyone help with a formular to get the right answer? Right now =-ABS(F4-G4)/ABS(F4)

 

[SirJB7]

Hi, kay!

That's the percentage of difference of G4 over F4. If you want the one of F4 over G4, invert them in the formula.

BTW, if the "right now" formula doesn't work for you, please define what do you mean by "% variance"; and if it does, why trying to find another formula?

Regards!

 

[Faseeh]

Hi Kay,


How are you?? I think we should stick to the basic definition of Percentage Variance i.e:

Variance Percentage = ((Actual-Ideal)/Ideal) x 100

I think you need to re-think what you are trying to accomplish with this formula that is more important..


BTW I was expect an email when i saw your post!!


Regards,

Faseeh