Nested IIfs

[JudithJubilee]

Hello,

I am using 2003. Is there a limit to the level of nesting in the IIF like
the seven limit in Excel??

If not is there a limit on the number of characters in a Custom field formula?


Thank you in advance

Judith

 

[John]

Hello,

I am using 2003. Is there a limit to the level of nesting in the IIF like
the seven limit in Excel??

If not is there a limit on the number of characters in a Custom field formula?


Thank you in advance

Judith

Judith,
I don't know if there is a limit on the number of nested "iif"
statements, but my guess is that since Excel has way more flexibility
with formulas than Project and if Excel has a limit, Project probably
does also. Did you actually run into a problem?

I've never actually tried it, but if there is a limit on the number of
characters in a formula line, it is probably 255.

However, even though I am responding with what may seem like non-helpful
information, based on your question I have some suggestions. If you are
anywhere near limits for nesting or formula length, you will be much
better off to break the single large calculation in multiple smaller
ones. The advantages are: much easier to enter, easier to troubleshoot
(and I'd say there is a 100% chance you will have to troubleshoot a
large formula at least once), no entry limits, and much easier to
understand what is being calculated.

Another suggestion, if you are thinking about doing moderate or heavy
calculations or decision logic, VBA may be a better approach. VBA has
more versatility and in some cases can even be set up to run
automatically. If you don't know VBA but would like to learn, we can
help with that.

John
Project MVP

 

[Jack Dahlgren]

Judith,
There is a 255 character limit which will limit the length of the formula
which I think you might reach around the same time as you made a seventh
level of nested iif statement. You can work around this by making a formula
which uses values from other fields with formulas in them.

I'm with Trevor though on the wisdom of creating such a complex statement.
What is it that you are trying to do with this? There may be an easier way.
Try describing your problem and perhaps someone here can help you.

There is also the switch statement and choose statement- which are similar
to a select case which may be worth looking at.

-Jack Dahlgren