Try this:

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

HTH,
Paul

"Jniedfeldt" wrote in message
...
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