Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Rogawski's Calculus Early Transcendentals For AP*

Authors: Jon Rogawski, Ray Cannon

2nd Edition

1464100543, 9781464100543

More Books

Students also viewed these Mathematics questions

Question

Describe ERP and how it can create efficiency within a business

Answered: 1 week ago

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago