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

"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