Answered step by step
Verified Expert Solution
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
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