how many "IF" can be used on a Formula

Hump · 03-13-2006, 07:45 AM

anyone can help me...

thanks,
Hump

**davesexcel** · 03-13-2006, 07:54 AM

There can be seven If statements,

Niek Otten · 03-13-2006, 07:55 AM

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten

"Hump" <[email protected]> wrote in message news:[email protected]...
> anyone can help me...
>
> thanks,
> Hump

Hump · 03-13-2006, 08:10 AM

thanks...

"Niek Otten" wrote:

> http://www.cpearson.com/excel/nested.htm
>
> --
> Kind regards,
>
> Niek Otten
>
> "Hump" <[email protected]> wrote in message news:[email protected]...
> > anyone can help me...
> >
> > thanks,
> > Hump
>
>
>

Niek Otten · 03-13-2006, 08:10 AM

There can be many more. But you can only *nest* 7 levels of functions. Nothing special about IF.

--
Kind regards,

Niek Otten

"davesexcel" <[email protected]> wrote in message
news:[email protected]...
>
> There can be seven If statements,
>
>
> --
> davesexcel
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=521673
>