How do I create If then statements

[Guest]

I am looking to create an if then statement to create an equation

If b5 is greater than or equal to B17; then b5*f1

If b5 is less than b17 then b5*f2

Can anyone help me form this into an excel cell to calculate?

Thank you

Julie Niedfeldt

 

[PCLIVE]

Try this:

=IF(B5<B17,B5*F2,B5*F1)

HTH,
Paul

 

[Chris Lavender]

Hi Julie
A straight If formula should do that:

=if(B5>=B17,B5*F1,B5*F2)

IF (condition, condition true, condition false)

Best regds

Chris Lav