What If statements - can you have a 3rd option??

[Lorna B]

Hi

I have a 'what if' statement which gives a results as Met or Missed but can I have this as Exceeded also.

=IF(C13>=B13,"MET","MISSED") is the current formula

I need to include if a staffs target of 8 is exceeded but 20% then CELL reads EXCEEDED?

Is this possible??

I hope that I am wording this some way that someone can understand.

Thanx

[arthurbr]

So if staff target is >9.6... exceeded ?
In which cell is the tested value?

[Whizbang]

=IF(C13>=B13+B13/5,"Exceeded",IF(C13>=B13,"MET","MISSED"))

With nested IF's, many things are possible.

[Lorna B]

Yes thats right.

Not too sure what your asking but i think its C13

Thanx

[Lorna B]

Oh my god!!

Thats brilliant!! thanx for your help..

[Lorna B]

Im probs going to ask a bit much here but how do you control the colours of a cell??

If MET - GREEN
If MISSES - RED
IF EXCEED - BLUE

????

[Whizbang]

Format->Conditional Formatting

Custom Formula, =C13<B13, desired format (Red)
Add
Custom Formula, =C13>=B13+B13/5, Desired Format (Blue)
Add
Custom Formula, =C13>=B13, Desired Format (Green)

[MartinjLane]

From the top menu try Format, conditional format and set the values as required

[Lorna B]

Brilliant -

Thanx everyone for the hand..