HELP Formula

S

santaviga

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
 
C

Carim

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
 
S

santaviga

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


Santaviga
 

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

Top