Afternoon everyone.

Have been struggling to get a formula together for the following. I am being
told due to its complexity that I will probably need to break it down into 2
sections but hoping someone can help me simplify things.

I need to do the following

A1 = 1 (although this can be 1,2,3,4,5) (This is my variable I am struggling
with)
B1 = ‚¬10000 (TARGET)
C1 - ‚¬6500 (ACTUAL)

Then I have a few boxes showing the following

<70% between 70-99% 100%
A5 = 1 B5 = 10% C5 = 15% D5 = 18%
A6 = 2 B6 = 12% C6 = 18% D6 = 21%
A7 = 3 B7 = 14% C7 = 21% D7 = 24%
A8 = 4 B8 = 16% C8 = 24% D8 = 27%
A9 = 5 B9 = 18% C9 = 27% D9 = 30%

So potentially there are 3 statements
1 showing under 70%
1 greater than 70% but less than 99%
1 greater than 100%

=IF(SUM(C1/B1)<70%,C1*B5
=IF(AND(SUM(C1/B1)70%<90%)),C1*C5 (I know this is wrong)

My problem is I now need to add the variable which is in A1 as it determines
the % applicable in the boxes above.

Apologies if this is confusing but hopefully I have explained it correctly

Thanks in advance for any help.