Need Help with If/Then Formula

I need help writing an If/Then statement in Excel.  I need to do ranges and the output differs based on the range.  For example, if the answer of a formula is between 0-10, what is displayed is a RED “NO”, if the answer is between 10.1 and 20 ,then the answer is a YELLOW “YES”, and if the answer is between 20.1-30, the answer is a GREEN “YES”.

By: Mike

Leave a Reply

Your email address will not be published. Required fields are marked *