Percentage.

[INTEX]

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]

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

 

[mzehr]

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