Help with MAX / MIN formula (I think)
Hi ,
I didn't complety understand what you want to achieve, I think you want to
multiply the amount in cell A1 by the % in column I and have the value
populated in B1.
=IF(A1<=10000,A1*I5,IF(AND(A110000,A1<=20000),A1* I6,IF(AND(A120000,A1<=30000),A1*I7,IF(AND(A13000 0,A1<=40000),A1*I8,IF(AND(A140000,A1<=50000),A1*I 9,I10)))))
"Mark D" 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
|