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