Excel formula help for calculate?

Rs.THIRTY to Rs.34.99 = Rs.SOME
Rs.27 to Rs.39.99 = Rs.7
Rs.45 to Rs.44.99 = Rs.9
Rs.45 to Rs.45.00 = Rs.10
But when excedd Rs.45.00 then it’ll calculate about difference total 2%.
we.e if it can be Rs.49.00 then on-line will Rs.TEN + ( FORTY NINE.00-45.00) a 2%

A1 is amount to check
A2 =INDEX(D:VE HAD, MATCH(A1, C:C, 1))

C1 get into 0, C2 get into 30, C3 get into 35, C4 get into 40, C5 get into 45, C6 get into 45.01
D1 get into 0, D2 get into 5, D3 get into 7, D4 get into 9, D5 get into 10, D6 =(A1-45)*2%+10

If your current amount is at A1:

=IF(AND(A1>=30, A1<35), SOME, IF(A1<40, 7, (IF(A1<45, BEING UNFAITHFUL, (10+(A1-45) * 0.02)))))

You didn’t say exactly what you wished it to try and do if the exact quantity is less than 30, in order that it will not handle which case.