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

Advertisements

M

Max

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

Advertisements

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

percentages 4
percentages 1
Percentage 2
percentages 4
percentage 2
Percentages 2
percentage 2
percentage 3

Top