Excel IF Function

  recap 10:38 06 Jun 2005

Trying to work a formulae out using the IF Function. One question on the IF function, how many arguments can be entered into the IF function?

  VoG II 11:18 06 Jun 2005

If you mean how many levels of nesting can you have, the answer is 7.

Otherwise we need more information.

  recap 13:30 06 Jun 2005

Thanks VoG™, that answers my question perfectly. Will have to find another way around the problem.

  compumac 13:52 06 Jun 2005

You can have a set of seven IF's nested, but the last IF can refer to yet another cell that carries another set of seven IF functions (relative to the first set)- and so on.

  VoG II 22:38 06 Jun 2005

If you need more help with this please contact me atclick here

It is possible to write IF statements in such a way that they resolve before the 7 nested levels come in to play.

  recap 08:19 07 Jun 2005

Thanks VoG™, much appreciated.

compumac, thank you for your suggestion.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017