Try:-

=IF(AND(C6=1,C6<=4),C45+C46,IF(AND(C6=5,C6<=8),C 45+(C46*2),IF(AND(C6=9,C6<=12),C45+(C46*3),"Out of range")))

Mike

"Foghat" wrote:

I want to programme so that if C6 is between 1 and 4 then the answer is Sum
of C45 and C46, if C6 is between 5 and 8 then the answer is sum of C45 and
C46(X2), if the C6 is between 9 and 12 then the answer is sum of C45 and
C46(X3)