Thread: Nested IF error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ricardo Monteiro :^)
 
Posts: n/a
Default Nested IF error

If A1 is <5, the result is "Cold"; if A1 is 5, the result is "Hot"; if A1 is
10, the result is "Very hot".


I tried different formulas from the help forum, but it keeps saying there's
an error.
I'm using Excel 2003 SP 2.

Thanks in advance