ExcelBanter - Problem with IF statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Problem with IF statements (https://www.excelbanter.com/excel-discussion-misc-queries/84201-problem-if-statements.html)

Problem with IF statements

Each one of thise IF statements works correctly by themselves and they all
worked okay up until the addition of the 6th one. Have I hit some maximum on
the usage of the IF statement? I was under the impression the maximum was 7.

=IF(C4<B4,(12+C4)-B4,C4-B4)+IF(E4<D4,(12+E4)-D4,E4-D4)+IF(G4<F4,(12+G4)-F4,G4-F4)+IF(I4<H4,(12+I4)-H4,I4-H4)+IF(K4<J4,(12+K4)-J4,K4-J4)+IF(M4<L4,(12+M4)-L4,M4-L4)

Problem with IF statements

Yes the max nested IF statements are 7. Use this link to solve your problem.
http://www.cpearson.com/excel/nested.htm

"Bob@HP" wrote:

Each one of thise IF statements works correctly by themselves and they all
worked okay up until the addition of the 6th one. Have I hit some maximum on
the usage of the IF statement? I was under the impression the maximum was 7.

=IF(C4<B4,(12+C4)-B4,C4-B4)+IF(E4<D4,(12+E4)-D4,E4-D4)+IF(G4<F4,(12+G4)-F4,G4-F4)+IF(I4<H4,(12+I4)-H4,I4-H4)+IF(K4<J4,(12+K4)-J4,K4-J4)+IF(M4<L4,(12+M4)-L4,M4-L4)