writing an "if" function that returns 3 possible vairable results based on the formula in a combination of 3 cells : I'm trying to write a formula that will do the following - if a1>b1 then (c2-d2)*f2, if a1<b1 but a1>c1, then (c3-d3)*f2, if a1<c1, then 0.

