ExcelBanter - How do I create If then statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I create If then statements (https://www.excelbanter.com/excel-discussion-misc-queries/49052-how-do-i-create-if-then-statements.html)

Jniedfeldt

How do I create If then statements

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

"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

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

"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

All times are GMT +1. The time now is 03:07 PM.