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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
The limit is 7 nested functions (IF or otherwise), which is clearly
documented in Help for "Excel specifications and limits" subtopic
"Calculation specifications"

Jerry
 
=?Utf-8?B?VXNlIG9mICdJRnMnIGluIE1TIEV4Y2VsLg==?= said:
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
Click to expand...

You can nest 7 If statements in one calculation
 
You must log in or register to reply here.

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

How fix a too long array function 5
IF OR AND in same conditional formula 2
Mix/Max/Avg Help based on dynamic ranges 16
Test of Multiple Conditions in an IF statement 3
IF function says too many nested 1
min if horizontal 0
Function Has Too Many Arguments 4
if bigger than 2

Back
Top