lets see if i get this correct  it will fit an IF statement  just getting the condition and maths correct
condition 1
IF A1 is less than 30 then multiply by 2 
condition 2
IF A1 is greater than 30 then 1 to 30 you muliply by 2 but any number greater than 31 and up to 60 multiply by 3 and then add the 2 together.
condition 3
If the number is greater than 60 then you add the 0 30 +30 60 + >60 forample if A1 = 35 then the answer would be 75. because:
trying to break it down
Quote:
IF A1 is greater than 30 then 1 to 30 you muliply by 2

if A1 is greater then 30  then there isnt a 130
it would just be (60 + ((A130)*3))
so in my IF statement that would be
=IF(A1<=30 , A1*2, IF( A1 >= 60, A1*4,
(60 + ((A130)*3))) )
Again if the number is greater than 60
you must have the
Quote:
y by 3 and then add the 2 together. If the number is greater than 60 then you add the 0 30 +30 60 + >60 forample if A1 = 35 then the answer would be 75. because:
(A1(A130))*2 +(A130)*3 = 75
If the number was greater than 60 ie A1 = 65 then the answer would be 170
0  30 = 30*2 = 60
30  60 = 30*3 = 90

60 and the 90 already  so that would be
(150 + ((A160)*4))
so in the formula
=IF(A1<=30 , A1*2, IF( A1 >= 60, A1*4, A1*3) )
that would be
=IF(A1<=30 , A1*2, IF( A1 >= 60,
(150 + ((A160)*4)) , A1*3) )
so the whole thing becomes
=IF(A1<=30 , A1*2, IF( A1 >= 60,
(150 + ((A160)*4)) ,
(60 + ((A130)*3))) )
unless i have missed understood completely