Hi,

Use

=IF(A4<0,0,MIN(4,ROUND(A4/25,0)))

where A4 is the % increase between A2 and A3. If you dont want any
rounding off of points, use

=IF(A4<0,0,MIN(4,A4/25))

Regards

Govind.


Trisha V via OfficeKB.com wrote:

ok that somewhat worked...if I needed the negative numbers to be 0?
and also They cant go over 100%? I think Im confusing both of us...lol

Govind wrote:

Hi,

If you already have a column that calculates the variance in % between
A3 and A2 then just use

=ROUND(A4/25,0) where A4 is the cell with the increase % between A2 and A3.

This formula rounds off to the nearest point. If the increase is say
70%, it would give 3 points (rounded off to 75%).

If you dont want any rounding off ,you can just do simply =A4/25.

Govind.

If you want only


ok and if I already have a column that calculates for example A3 and A2?


[quoted text clipped - 14 lines]

how would i a formula that would read this?