Problem with IF statements

B

Bob@HP

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

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
Concatenate into 1 cell and drop down lines? 4
if function error 3
Forecast a date from data given 4
=IF((I4="R");H4;IF((H4>0);H4*E4;IF((I4=0);J4*E4;IF((J4>H4);J4*E4) 2

Top