Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXCEL IF FUNCTION Use the IF statement to put a star in each row where the students grade is equal to or higher than the

EXCEL IF FUNCTION

Use the IF statement to put a star in each row where the students grade is equal to or higher than the class average in the Info Column; The star should be left-aligned within the column

---------

=IF(B4>=B17,"*")

I have used this formula but in a seperate column

I would need the * to appear in B4 for the formula above, how can I tell the * to appear in a cell that it is already pulling from?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Cornerstones Of Cost Management

Authors: Don R. Hansen, Maryanne M. Mowen

3rd Edition

9781305147102, 1285751787, 1305147103, 978-1285751788

Students also viewed these Finance questions