Hi experts,
I am new to the site, so I apologize if I have posted this in the incorrect area.
In the below table I have the following formula in C3-C5,
=IF(B3=1,$D$2,IF(B3=2,$E$2,IF(B3=3,$F$2,IF(B3=4,$G$2))))
<tbody>
</tbody>
As you can see if I change the number in B3-B5 the value in C3-C5 changes.
If I change B3 to 2, C3 changes to Pause.
I am trying to come up with a formula if I change B3 to 2, it can see E3 is 0 and it automatically changes to the next cell that contains a value other than 0 in this example it would be F2 (Re-set).
If I was to use B5 as the example and entered 2 in B5 it would return Stop as E5 and F5 both have 0.
I can substitute the 0 to blank cells if that makes it easier.
Thanks,
Gavin
I am new to the site, so I apologize if I have posted this in the incorrect area.
In the below table I have the following formula in C3-C5,
=IF(B3=1,$D$2,IF(B3=2,$E$2,IF(B3=3,$F$2,IF(B3=4,$G$2))))
A1 | B | C | D | E | F | G |
2 | | | Start | Pause | Re-set | Stop |
3 | 1 | Start | 1 | 0 | 1 | 1 |
4 | 4 | Stop | 1 | 1 | 1 | 1 |
5 | 3 | Re-set | 1 | 0 | 0 | 1 |
<tbody>
</tbody>
As you can see if I change the number in B3-B5 the value in C3-C5 changes.
If I change B3 to 2, C3 changes to Pause.
I am trying to come up with a formula if I change B3 to 2, it can see E3 is 0 and it automatically changes to the next cell that contains a value other than 0 in this example it would be F2 (Re-set).
If I was to use B5 as the example and entered 2 in B5 it would return Stop as E5 and F5 both have 0.
I can substitute the 0 to blank cells if that makes it easier.
Thanks,
Gavin