Help with another IF THEN

[ArtBOM]

How do I write a formula for: IF B<400, THEN (H*L)*150, IF B>400, THEN (H*L)*160. What is this type of formula called?

 

[kweaver]

IF B what? B1, B100, ??? You need to write the formula using cell references with the column letter and row number.
For example: =IF(B1<400,H1*L1*150,H1*L1*160)
What happens if the value is =400? In this example, it'll use the latter calculation.

Syntax is: =IF(logical_test,action_if_true,action_if_false)

 

[jtakw]

Hi,

Assuming you mean <400, and >=400:

Book3.xlsx
	B	C					H				L
1	399	900					2				3
Sheet720

Cell Formulas
Range	Formula
C1	C1	=H1*L1*IF(B1<400,150,160)

 

[ArtBOM]

IF B what? B1, B100, ??? You need to write the formula using cell references with the column letter and row number.
For example: =IF(B1<400,H1*L1*150,H1*L1*160)
What happens if the value is =400? In this example, it'll use the latter calculation.

Syntax is: =IF(logical_test,action_if_true,action_if_false)

That did it, thank you. I started with =IF(B2<400,H2*L2*150,H2*L2*160) and copied it down the sheet. It worked! Thanks again!

 

[ArtBOM]

Hi,

Assuming you mean <400, and >=400:

Book3.xlsx
	B	C					H				L
1	399	900					2				3
Sheet720

Cell Formulas
Range	Formula
C1	C1	=H1*L1*IF(B1<400,150,160)

Thank you!