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

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
Excel.@discussions.microsoft.com> wrote in message
news:65B06F94-07B5-4C6D-AF7F-23EEE2F8DEF3@microsoft.com...
>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
Excel.@discussions.microsoft.com> wrote in message
news:65B06F94-07B5-4C6D-AF7F-23EEE2F8DEF3@microsoft.com...
>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

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

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

=?Utf-8?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

=?Utf-8?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

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
Excel.@discussions.microsoft.com> wrote in message
news:65B06F94-07B5-4C6D-AF7F-23EEE2F8DEF3@microsoft.com...
>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

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

=?Utf-8?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