• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Writing inequality equations

K

Kamarlon

New Member
I want to do the following:


If the score is equal to or greater than 0.75 the word "Well Done" is to appear,

0.5 - 0.74 the words "Good Effort" must appear and if the score is less than 0.5 the words "Needs Imrovement" must appear. Does anyone know how to write this inequality. The one I have does not work correctly. This is what I have:

IF(Stats!K37>0.74,"Well Done",IF(0.4<Stats!K37<0.75,"Good Effort!","Needs Improvement"))


NB. The cell Stats!K37 Ccontains the score.
 
You could also use this formula, which allows you to easily add in other levels later if you want:


=If(Stats!K37<.5,"Needs Improvement",If(Stats!K37<.75,"Good Effort!","Well Done"))
 
Thank you vaskov 17 and OleMiss2010. Formulas worked. I used OleMiss2010's suggestion as I think another level may be included. Thanks again guys.
 
You must log in or register to reply here.
Back
Top