Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW MANY 'IF CONDITIONS' CAN BE USED IN ONE SUCH USAGE?
I have 5 by 7 matrix. If I use If statement it becomes to long. Will MS-Excel
accept any number of 'IFs'? If so, how many 'IFs' can I use? Thanks |
#2
|
|||
|
|||
Hi
Usually if you are nearing the maximum number of nested IFs (which is 7) there are better ways to get to what you want! Post what you have and what you are trying to achieve in detail and I'm sure you'll get some suggestions. -- Andy. "Use of 'IFs' in MS Excel." <Use of 'IFs' in MS wrote in message ... I have 5 by 7 matrix. If I use If statement it becomes to long. Will MS-Excel accept any number of 'IFs'? If so, how many 'IFs' can I use? Thanks |
#3
|
|||
|
|||
The limit is 7 nested functions (IF or otherwise), which is clearly
documented in Help for "Excel specifications and limits" subtopic "Calculation specifications" Jerry Use of 'IFs' in MS Excel. wrote: I have 5 by 7 matrix. If I use If statement it becomes to long. Will MS-Excel accept any number of 'IFs'? If so, how many 'IFs' can I use? Thanks |
#4
|
|||
|
|||
?B?VXNlIG9mICdJRnMnIGluIE1TIEV4Y2VsLg==?= Wrote: I have 5 by 7 matrix. If I use If statement it becomes to long. Will MS-Excel accept any number of 'IFs'? If so, how many 'IFs' can I use? Thanks You can nest 7 If statements in one calculation -- TMinterPosted from http://www.pcreview.co.uk/ newsgroup access |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
should be possible to add more conditions to conditional formatti. | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |