How do you have multiple out comes for the same if condition in

Closed
J9 - Jan 24, 2017 at 11:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 24, 2017 at 11:40 AM
Hello,

I have a condition in my file such that =IF(C5=C4,D3+1,D5=1 ->>>> trying to add this andD4= D3+1)

Basically this what I want to happen Column C D3

12345 1
12345 2 <-formula starts here
12345 3
12346 1
How do I have two outcomes when a condition is met?

Thanks!


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 24, 2017 at 11:40 AM
Hi J9,

Not sure what you mean by having 2 outcomes, but the screengrab below is how I foresee your query.


Does this solve your query?

Best regards,
Trowa