How to write multi-conditional IF function? Ask God for help. Please outline your problem here.
Write the formula in G 1: "= if (and (e 1 = b 1, f 1 = c 1)," to be settled ",if (and (e1>. 0,f 1 & gt; 0), "unpaid freight", if (e1> 0, "unpaid", if (f1> 0, "unsettled freight", "settled") ",drop down and copy to other cells.