Thread: Nested IF error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Nested IF error

On Fri, 3 Feb 2006 06:33:10 -0800, "Ricardo Monteiro :^)"
wrote:

That's working, but I try to add more and it says it has too much.
Any help?

Thank you both.

"Don Guillett" escreveu:

try working from the top down
=if(a110,"very hot",if(a15, "hot","cold"))


Without more detail, it's hard to say.

I've not seen an error message that says "too much". Is that the full text of
the error message?

There is a limit of seven nested functions.
--ron