Calculate Value

[creativefusion]

Hi All,

Cell A1 has a value of 90% expressed as a utilisation percentage.
Cell A2 has a value of 100.

In cell A3, I am wanting to multiply the value of A2 by the difference of A1 (for example, A1 is 90%, I have 10% redundancy available).

For example: -

100 (original value) x 10% (redundancy) = 10
End result should be 110

Thanks.

[windknife]

You meaning is ?
A1 = 90%
B1 = 100
C1 = B1 * (2-A1)

So, C1 will become 110

[Jimmy0306]

Forgive me if I am being too simplistic, but would the formula be something like:
=(((A2-A1)/100)*A2)+A2
A1=90 A2=100 A3= Formula result of 110

[creativefusion]

Hi Jimmy,
Thanks heaps for the solution, it works a treat. Cheers, CF