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!!