If statement to bring back great or less and apply rates

[alexc2022]

Hi, I have a column hours and rates. Under the sum column im trying to do an if statement to bring back the following - If =IF(B2<37.5,"*D2,"2",)if(B2<37.5,"*D2,"1.5",)

If its less than 37.5 hours x the rate column 1.5 and if its less than 37.5 x the rate column by 2. At the moment it bring back value.

Please could I have help with my formula and guidance to where im going wrong?

[AliGW]

Do you mean this?

=D2*IF(B2<37.5,1.5,2)

guidance to where im going wrong?

I couldn't get my head around what you thought your formula was doing, but if you put numbers into inverted commas, they are text, not numbers.

[alexc2022]

What I need to cell E2 to lookup the hours and if its less than 37.5 x rate by 2 if its more than 37.5 x rate by 1.5.

[Sam Capricci]

you seem to be saying the same thing twice but with different outcomes?

If its less than 37.5 hours x the rate column 1.5 and if its less than 37.5 x the rate column by 2.

[AliGW]

What I need to cell E2 to lookup the hours and if its less than 37.5 x rate by 2 if its more than 37.5 x rate by 1.5.

Did you try my suggestion?

[Sam Capricci]

I think this is what you want... =IF(B2="","",IF(B2<37.5,D2*2,D2*1.5))

edit: BTW, putting numbers in quotes makes them into text and then you cannot use them to multiply by without making changes to other formulas.

[alexc2022]

Thank you all for the advice this has now worked

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.