View Single Post
  #2   Report Post  
Old January 14th 05, 12:55 PM
Ron Rosenfeld
Posts: n/a

On Fri, 14 Jan 2005 03:09:02 -0800, Linda Bolton <Linda

I am entering and IF expression with more than 7 nested functions. Is there
another way to enter formula which would work?


You can not nest more than seven functions in Excel, so a different approach
must be used.

If AG6 will always be an integer, then:


should give the equivalent result.

If AG6 might not always be an integer, then you need to post back with what you
would like to do in that event.