if then function

[Tricia]

Hi I am trying to make a formula which does the following

if A2 is less than equal to 225 then multiply A2 by cell B2 else if A2 is
more than 225 then multiply 225 by cell B2 then subtract 225 from cell A2
and multiply the remainder by cell C2 then add the 2 figures together.

i.e. if A2 is 200 then multiply by B2, if A2 is 300 then subtract 225 from
300 (gives 75) multiply 225 by B2 and multiply 75 by cell C2 and add the 2
together. Hope you can understand all this.
Thank you in advance Tricia

 

[Zack Barresse]

Hi Tricia,

How about something like this ...

=IF(A2<=225,B2*A2,(A2-225)*C2+(B2*225))

 

[Bernard Liengme]

And with no IF insight:
=(A2<=225)*(A2*B2)+(A2>225)*((A2-225)*C2+(B2*225))
best wishes