Percentage.

INTEX · Aug 12, 2004

If I have two values ie, 2 & 4, the second value is a
100% increase on the first value, how do i show this in a
formula.

Max · Aug 12, 2004

One way ..
With A1: 2, B1: 4
Put in C1: =(B1-A1)/A1
Format C1 in percentage

mzehr · Aug 12, 2004

Hi,
Try

=IF(base=0,"",(current-base)/ABS(base))

Takes into account the possibility that the base is 0 or
one of the amounts is negative