changing multiplier IF......

Please can anyone help me.

I have two numbers A and B
A is any number between 1 to 40
B=80
C=A*B
I want a formula that when A is greater than 40 , B will change to 100.

You need to use another cell and use formula:

=IF(A1>80,100,B1)

so if A1 is greater than 80 cell value = 100 if not cell value = B1 (1 to 40)

You don't need another cell. Just paste this in C1:

=if(A1>40;A1*100;A1*B1)

Although I would put the value 100 in a cell as well, keeping it dynamic... ;-)

Peter

Thank you both for the help. The two formulae work fine.