مطالب مرتبط با «excel formulas if or nested» در Recent Questions | نویسنده: استخدام کار
Excel Formula - IF/OR
I'm trying to run a ruing total where if the conditions are met with "Won" or "Placed" it will automatically run the sum. However part of this formula is not working the way I would like as it's displaying FALSE in the column when "Won" is the selection. When "Placed" is selected is runs the sum fine. Original formula: =IF(I3="Won",(E3*(G3-1))*0.95,-E3) Formula with Placed added: =IF(OR(I3="Won"),OR(I3="Placed"),(F3*(H3-1))*0.95) Sorry if I haven't explained this well as I'm not very good with excel! Any help would be greatly appreciated!! Let's block ads! بخوانید...
ادامه مطلب
