HELP Formula
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
|