What would be the remarks in cell E10 that valued 75 which noted, if - ProProfs Discuss
Advertisement

What would be the remarks in cell E10 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be PASSED or else FAILED?

What would be the remarks in cell E10 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be PASSED or else FAILED?<br/>

Change Image    Delete

Asked by Lorie, Last updated: Nov 09, 2024

+ Answer
Request
Question menu
Vote up 1 Vote down

4 Answers

Robert Hazlewood

Robert Hazlewood

Here to relax my mind a bit

Robert Hazlewood
Robert Hazlewood, Senior Executive, MBA, Louisville

Answered May 30, 2019

The right formula is going to be +IF(E10>74, "PASSED," "FAILED"). The use of excel has made it so much easier for a lot of people to computing for different things. There are a lot of professors who use excel in computing the grades of their students.

The professors need to input the grades that their students have received to the different tests, recitation, projects, and so much more. They will get the total, and if the average is below 74, then the word FAILED will appear on the designated cell. If the grade is 75 and above, then the word PASSED will appear. This can make things easier for the professor for sure.

upvote downvote
Reply 

W. Kaye

W. Kaye

Here to answer and learn

W. Kaye
W. Kaye, Ex-Marine, Post Graduate, Chapel Hill

Answered Apr 19, 2019

The remarks will be: +IF(E10>74,"PASSED","FAILED"). There are some people who may get confused with placing the right remarks and formulas. It is important to know the different formulas available because this will make the computation of several numbers faster.

Plus, there will be details about the grade so those who are looking at the sheet will only have to find their names to know if they have passed or not. This is something that teachers may do now. They will just share the spreadsheet file to the rest of the class for more details. Some teachers and professors will also allow their students to compute their own grades.

upvote downvote
Reply 

Elizabeth A Nygren

Elizabeth A Nygren

Elizabeth A Nygren
Elizabeth A Nygren

Answered Aug 15, 2018

+IF(E10>74,"PASSED","FAILED")

upvote downvote
Reply 

lorie

lorie

lorie
Lorie

Answered Jul 28, 2018

=if(e10>74,"passed","failed")
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.