On Jul 3, 10:25 pm, "JoeH" wrote:
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.

=C20 * if(L20<30, L20, if(L2036, F20, I20))