HOW MANY 'IF CONDITIONS' CAN BE USED IN ONE SUCH USAGE?

  • Thread starter Use of 'IFs' in MS Excel.
  • Start date
U

Use of 'IFs' in MS Excel.

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
 
G

Guest

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
[email protected]> wrote in message
news:[email protected]...
 
J

Jerry W. Lewis

The limit is 7 nested functions (IF or otherwise), which is clearly
documented in Help for "Excel specifications and limits" subtopic
"Calculation specifications"

Jerry
 
T

TMinter

=?Utf-8?B?VXNlIG9mICdJRnMnIGluIE1TIEV4Y2VsLg==?= said:
I have 5 by 7 matrix. If I use If statement it becomes to long. Wil
MS-Excel
accept any number of 'IFs'? If so, how many 'IFs' can I use?
Thanks
Click to expand...

You can nest 7 If statements in one calculatio
 
Top