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 to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Foundations In Personal Finance

Authors: Dave Ramsey

3rd Edition

1936948524, 978-1936948529

More Books

Students also viewed these Finance questions