Apply of different formulas based on different conditions

[sejur2002]

Hello,
I'm a beginner and I don't know how to apply the following formula in the "Make" cells:
-If B4 is <50 then B5 is zero.
-If B4 is between 50 and 100 then B5 is B4*B5%*1.5%
-If B4>100 then B5 is B4*1.5%
Thank you!

 

[Joe4]

Welcome to the Board!

I think you have a typo in the middle rule. Can you clarify?

If B4 is between 50 and 100 then B5 is B4*B5%*1.5%

(not sure what B5% is)

 

[Joe4]

If we can rule 2 "rule 2" (while waiting for you to clarify that), the structure of your formula would be:

=IF(B4>100,B4*1.015,IF(B4>=50,Rule 2,0))

 

[Scott Huish]

=B4*LOOKUP(B4,{0,50,101},{0,0.015,0.015})

Replace the red bold value with what you want to multiply the middle value by.

 

[sejur2002]

First of all, thank you all for the answers!
@Joe4
I made a mistake in my post, i am sorry! If B4 is between 50 and 100 then B5 is B3*B4%*1.5%, i meant the value from B4 is percent.
In B column if B4=49.9 (B4<50), then B5=B3*0.499*0.
If B4=51 then B5=B3*0.51*0.015.
If B4=101 then B5=B3*0.015

 

[Joe4]

First of all, thank you all for the answers!
@Joe4
I made a mistake in my post, i am sorry! If B4 is between 50 and 100 then B5 is B3*B4%*1.5%, i meant the value from B4 is percent.
In B column if B4=49.9 (B4<50), then B5=B3*0.499*0.
If B4=51 then B5=B3*0.51*0.015.
If B4=101 then B5=B3*0.015

You should just be able to follow the pattern I gave you and substitute the formulas where needed, i.e. put this formula in cel B5:

=IF(B4>100,B3*0.015,IF(B4>=50,B3*0.51*0.015,0))

Note that ANYTHING times zero is zero, so this is just zero:

=B3*0.499*0