Mike Slattery
Board Regular
- Joined
- Dec 11, 2004
- Messages
- 101
=IF(CN3>CW3,CN3,IF(CW3>CN3,CW3,#N/A)) is my current formula.
I would like to limit the results so that if the first IF() is true it would output CN3 and then it would not return any more results from that condition until there had been one instance of the second IF() being true outputting CW3.
From that point on I want to switch the priority back and forth.
So if CN3>CW3, it would stop checking this condition until there was an instance of CW3>CN3. Then go back to looking for the first condition and continue switching through all of the data range..
Thanks, Michael
I would like to limit the results so that if the first IF() is true it would output CN3 and then it would not return any more results from that condition until there had been one instance of the second IF() being true outputting CW3.
From that point on I want to switch the priority back and forth.
So if CN3>CW3, it would stop checking this condition until there was an instance of CW3>CN3. Then go back to looking for the first condition and continue switching through all of the data range..
Thanks, Michael
Last edited: