Excel Formula - IF/OR

خرید بک لینک

I'm trying to run a running 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!!

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: excel formula if or,excel formula if or multiple conditions,excel formula if or condition,excel formula if or then,excel formula if or and together,excel formula if or range,excel formula if or text,excel formulas if or nested,excel formula if yes or no,excel formula if equal or greater than, نویسنده: استخدام کار بازدید: 304 تاريخ: دوشنبه 18 مرداد 1395 ساعت: 18:53

صفحه بندی