| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement Problem | Excel Worksheet Functions | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
| Use SQL statements in Excel VBA to query SQL Server Data Problem | Excel Worksheet Functions | |||
Hybrid Mode
