Percentage.

I

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.
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Formula Custom Formatting 4
Calculation of average improvement? 0
Increasing all values in spreadsheet by same percentage. 1
Formatting Percentages/LOOKUP using a Percentage 2
Formula Help 1
Increase a value by a % with result showing in original cell? 1
Formula 3
If Formula 2

Top