. 0,f 1 & gt; 0), \"unpaid freight\", if (e1> 0, \"unp" />
Current location - Trademark Inquiry Complete Network - Futures platform - How to write multi-conditional IF function? Ask God for help. Please outline your problem here.
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.