What is wrong with this nested function?

[A little stuck]

I have entered the following nested function, but it says the formula
contains an error.

=IF(SUM(E55:E67)>=3, "Red"), (SUM(D5567)>=2, "Amber"), "Green"

Basically, I want the word, "Pink" to appear if SUM(E55:E67)>=3; the word,
"Yellow" to appear if SUM(D5567)>=2; and the word "Blue" to appear
otherwise.

Anyone know how I can do this? Any help would be much appreciated.

 

[Max]

Basically, I want the word, "Pink" to appear if SUM(E55:E67)>=3; the word,

"Yellow" to appear if SUM(D5567)>=2; and the word "Blue" to appear
otherwise.

On the face of it, try this:
=IF(SUM(E55:E67)>=3,"Pink",IF(SUM(D5567)>=2,"Yellow","Blue"))

The IF evaluates from left to right. Since you are testing 2 different
ranges, the sequence of the test becomes important. If the 1st IF test is
TRUE, you'd get "Pink" irrespective of the result from the 2nd IF test (which
will never get evaluated).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[A little stuck]

Perfect!! Thank you.

On the face of it, try this:
=IF(SUM(E55:E67)>=3,"Pink",IF(SUM(D5567)>=2,"Yellow","Blue"))

The IF evaluates from left to right. Since you are testing 2 different
ranges, the sequence of the test becomes important. If the 1st IF test is
TRUE, you'd get "Pink" irrespective of the result from the 2nd IF test (which
will never get evaluated).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Lars-Åke Aspelin]

On Tue, 14 Jul 2009 17:18:01 -0700, A little stuck <A little

I have entered the following nested function, but it says the formula
contains an error.

=IF(SUM(E55:E67)>=3, "Red"), (SUM(D5567)>=2, "Amber"), "Green"

Basically, I want the word, "Pink" to appear if SUM(E55:E67)>=3; the word,
"Yellow" to appear if SUM(D5567)>=2; and the word "Blue" to appear
otherwise.

Anyone know how I can do this? Any help would be much appreciated.

Try the following formula that is syntactically correct:

=IF(SUM(E55:E67)>=3, "Red", IF(SUM(D5567)>=2, "Amber", "Green"))

However you may have to check the spelling of the colors (Pink, Yellow
and Blue).

Hope this helps / Lars-Åke