Hi Need help with a formula.

I need a formula to report in a cell if a range of figures fall below a
difference of a figure.
Donald £2.00
Mick £5.00
Luke £10.00
Jack £20.00

e.g.

Cell would recognise the £20.00 as the maximum value of the column and I
need a formula to report any other values which is less than the £20.00 minus
£10.00, so the cell would report €œChase Up€� for the £2.00 and the £5.00 and
other values that fall less than £10.00 below the maximum. The maximum will
change on a weekly basis so the formula must recognise the maximum at all
times and report €œChase Up€� if any other cells fall below the £10.00
difference.

Can any one Help me with this formula?

Regards

Hi,

If your cells in pounds are located in B1:B4,
in cell C1 just type:
=IF(B1<(MAX($B$1:$B$4)-10),"Chase UP","")
and copy down ...

HTH
Cheers
Carim

Hi, this formula doesn't seem to be returning anything when tested.

Santaviga

"Carim" wrote:

Hi,

If your cells in pounds are located in B1:B4,
in cell C1 just type:
=IF(B1<(MAX($B$1:$B$4)-10),"Chase UP","")
and copy down ...

HTH
Cheers
Carim

Sorry my mistake, works fine, was entering wrong values in pounds. Thanks a
lot for your help. Much appreciated.


Santaviga

"Carim" wrote:

Hi,

If your cells in pounds are located in B1:B4,
in cell C1 just type:
=IF(B1<(MAX($B$1:$B$4)-10),"Chase UP","")
and copy down ...

HTH
Cheers
Carim