If Then Statements

[Guest]

Need help. Need to turn the following into a formula within Excel.

If B19>45 then A19
If B19>=45 but <100 then B19*A20
If B19>=100 but <300 then B19*A21

Thanks,

 

[Frank Kabel]

Hi
try
=IF(B19>=100,IF(B19<300,B19*A21,"not defined"),IF(B19>=45,B19*A20,A19))

I assumed that your first condition should read B19<45

 

[Guest]

Hi, yes the first condition should be <.
Works likes a charm.

Thanks very much,

Mark