Problem with IF statements

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate into 1 cell and drop down lines? 4
Returning last number(time) in a row of cells 4
How do I ignore blank cells while averaging the solutions of equat 2
Leave final cell blank 2
When IF has limited iterations 10
Forecast a date from data given 4
Circular Reference will not solve #VALUE! or #DIV/0! 7
Function Help 3

Top