Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please let me know the nested if statement formula in excel for the follow: If less than 200 - red If equal to 200 or
Please let me know the nested if statement formula in excel for the follow:
- If less than 200 - red
- If equal to 200 or less than 1000 - yellow
- If 1000 or greater - green
I need to know the nested excel IF formula that will have all in one column and the words to populate if the number range is met. Let's assume this is column B and the range of cells is 25 - B1-B25.
Thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started