If Then Statements

M

mh4568

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,
 
F

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
 
M

mh4568

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

Thanks very much,

Mark
 
Top