IF Formula needs adjusting to add different variables!

[bhandley]

Hello all,

I have this formula:

=IF(F2>=8,CHOOSE(A2,185,205,275),IF(F2<3.5,CHOOSE(A2,28,32,45)*F2,CHOOSE(A2,95,115,165)+CHOOSE(A2,28,32,45)*(MAX(F2-4,0))))

However, i need to make it so that:


If:

A2=1 & F2 is between 3.4-4 then G2=95
A2=1 & F2 is between 6.6-8 then G2=185

A2=2 & F2 is between 3.6-4 then G2=115
A2=2 & F2 is between 6.4-8 then G2=205

A2=3 & F2 is between 3.6-4 then G2=165
A2=3 & F2 is between 6.1-8 then G2=275

Also, as you can see in the formula, these (G2) are flat rates and then anything over (F2 4 or 8) are charged hourly on top of the flat rates.

This might seem confusing so ask me if you need any clarification.

Regards,

Braden