#### johnwill8258

##### New Member

- Joined
- Sep 15, 2016

- Messages
- 14

=IF(OR(OR(OR(G15>=0.01, G15<=-0.01), K15>0.01), L15>=0.01,), IF(N14<>"", N14,

Above formula is applied to a table column. This equation will pretty much check several cells(G,K,L), then check N cell's(current N15) above cells if any are empty, if not allow skipping

I would like to allow skipping more than one cell. In order to do that, I will need to change up

Thank you

**N13**)-G15+K15-L15-M15, "")Above formula is applied to a table column. This equation will pretty much check several cells(G,K,L), then check N cell's(current N15) above cells if any are empty, if not allow skipping

*one*cell, but no more, otherwise leave it blank.I would like to allow skipping more than one cell. In order to do that, I will need to change up

**N13**part in IF(N14<>"", N14, N13), where N13 part will instead recursively call N14<>"", N14 portion, with decrementing N14. Is there a excel formula that enables that? Or if you have suggestion for another method, let me know.Thank you

Last edited: