I'm a bit confused as to what you want in B31:B37, but try this:

=VLOOKUP(A$1,G$5:I$11,3)

It will return the appropriate percentage from column I dependent on
your total in A1.

I assume your currency amounts are proper numbers formatted as
currency, and not text values.

Hope this helps.

Pete

On Jul 27, 10:45*am, Mark D <Mark
wrote:
Morning all

I am sorry if this request seems quite basic but I am absolutely stuck on
how to enter this forumla and am really hoping someone can help me. I think I
need to use a MAX / MIN formula

If I have a total figure in A1 which say has €100,000 in it.

Then i have some TO & FROM amounts in other columns starting at G5 and
working down

TO * * * * * * * * *FROM * * * * * * * % AMOUNT APPLIED
G5 - G11 * * * * H5 *- H11 * * * * * I5 - I11
€0 * * * * * * * * €10,000 * * * * * * * 10%
€10,001 * * * * €20,000 * * * * * * * 15%
€20,001 * * * * €30,000 * * * * * * * 20%
€30,001 * * * * €40,000 * * * * * * * 30%
€40,001 * * * * €50,000 * * * * * * * 40%
€60,000 * * * * * * * * * * * * * * * * * 45%

Then from B31 down to B37 based on the figure in A1 show the value in B31 -
B37 that applies based on the criteria in columns G, H & I

G11 actually has no end value so anything higher than €60,000 will always be
at 45%

Again thanks for anyone that can help me with this. I have tried everything
and am going out of my mind

Kind Regards

Mark