M
Mark D
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
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