I need to add in two additional conditions to the following formula:
If I3 = Lost = -1
If I3 = N/A = 0
Any help would be greatly appreciated!
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
To test multiple conditions, you need to nest IF functions:
The best solution would be a chain of
=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.