Home » Forums » Open Source Learning Center » Question and Answer

Display text in cell when target value reached

Submitted by Bishbosh1 on 22 March, 2013 - 11:25

Hi Guys,

Unsure if this is possible so here goes:

Total value in Cell H9

1st Target value in cell I9 (If H9 is =>I9 but 2nd Target value in cell J9 (If H9 is=>J9 but 3rd Target value in cell K9 (If H9 is=>K9 but 4th Target value in cell L9 (If H9 is=>L9, display text “extra mile”

In cell G the target achieved to display as “text” (depending on value reached in Cell H9, “not achieved, achieved, exceeded or extra mile”.

I hope this makes sense, apologies if not.

Thank you for looking into this headache!

‹ Making Rule work on Select Columns Test Questions Upload ›
»
Nick's picture

conceptually, if you want to

Submitted by Nick on 22 March, 2013 - 15:45.

conceptually, if you want to add text to a score, and the score is in A1, you'd use something like this:

=IF(A1>90,"wow",IF(A1>80,"good",IF(A1>50,"average","unclassified")))

- so first check if the value is greater than the highest threshold, then next.. etc..
- "unclassified" is your catch-all at the end

»