Hi,

I need help on variance % in excel. With the below given numbers, my variance % should be +ve instead of -ve.

Can someone help me in getting one formula with different scenarios.

1)

CY |
PY |
Var % |
Formula used |

28,390 |
(19,176) |
-168% |
B3/A3-1 |

2) In the below example, we should have a unit value with -ve number instead of +ve.

CY |
PY |
Unit value |
Formula used |

(28,390) |
(19,176) |
0.68 |
B3/A3 |

In both of the examples i need, the % formula where PY should be a denominator?