How do I create If then statements

J

Jniedfeldt

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
 
C

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
 
Top