I need to add in two additional conditions to the following formula:
If I3 = Lost = -1
If I3 = N/A = 0
=IF(OR(I3="Won",I3="Placed"),(F3*(H3-1))*0.95)
Any help would be greatly appreciated!
I need to add in two additional conditions to the following formula:
If I3 = Lost = -1
If I3 = N/A = 0
=IF(OR(I3="Won",I3="Placed"),(F3*(H3-1))*0.95)
Any help would be greatly appreciated!
To test multiple conditions, you need to nest IF functions:
=IF(OR(I3="Won",I3="Placed"),(F3*(H3-1))*0.95,IF (I3="lost",-1,0))
The best solution would be a chain of if
s:
=IF(first condition,first value,IF(second condition,second value,IF(third condition,third value,else)))
You can make that as long as you want.