formula help

  • Thread starter Thread starter Melanie
  • Start date Start date
M

Melanie

does anyone know how to add another condition into an
already-complex formula?

I have built a spreadsheet to handle environmental data.
In one of the cells, i have entered a formula that looks
up the cell above, and returns a value depending on
what's in that cell (see formula below)

IF($D$23="B","Stage 4",IF($D$23="C","Stage 3",IF
($D$23="D","Stage 3: Below expectation","")))

That's fine, but now i want to add another condition.
THe above formula should still stand, but if another box
contains the letter 'i', then i want to return a
different answer ("Stage 3: Investigation required") that
overrides the other three possible returned values. How
do i do this? Urgent assistance required!!! I have 2
working days to come up with this....
 
Hi try
IF($E$23="i","Stage 3: Investigation required",IF($D$23="B","Stage
4",IF($D$23="C","Stage 3",IF
($D$23="D","Stage 3: Below expectation",""))))
 
Frank
What can i say?
You are a legend. May you recieve the gift of 1000
camels!
All the best
Melanie
 
Hi Frank!

When the camels come, reserve a pretty one for me and I'll be there.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top