I am trying to develop a worksheet where my sum will vary depending on
whether another cell is greater than one number, greater than or less than
another number and less than another number. A second multiplier depends on
this criteria. An example would be if cell L20was <30 then C20 would be
multiplied by cell L20. If it was <36 It would be multiplied by I20and if
it was 36 it would be multiplied by cell F20. I am trying to enter the
formula into cell M20. Hope this makes sense. Thanks in advance.