Hello, I have a problem how to write a command that has an if function. It is supposed to look like that if there are no grades in a given cell, the message no grades will appear. I have no idea how to do it. I am counting on help :)

The if function checks if the cell is equal to 0 (empty). If the statement is true, insert no marks.

Okay, but I have to calculate the average by the way, I forgot to add ?. So it is to calculate the average rating and by the way, if the cell is empty, it is to write no ratings

I suggest a formula like in the screenshot 2018-11...png (12.54 kB)You must be logged in to download this attachment.

Creating an IF Function in Excel to Display 'No Grades' in Empty Cells

Report a violation of the law

Reply | New topic

#1 17585724 25 Nov 2018 22:15

kreizo kreizo

Level 2

Posts: 2

Rate: 1
» | Topic author

Post #1
17585724 25 Nov 2018 22:15

Hello,
I have a problem how to write a command that has an "if" function. It is supposed to look like that if there are no grades in a given cell, the message "no grades" will appear. I have no idea how to do it. I am counting on help
ADVERTISEMENT
#2 17585927 26 Nov 2018 00:09

kacpo1 kacpo1

Level 33

Posts: 1698

Help: 273

Rate: 156
» | Helpful post? (0)

Post #2
17585927 26 Nov 2018 00:09

The "if" function checks if the cell is equal to 0 (empty). If the statement is true, insert "no marks".
ADVERTISEMENT
#3 17586180 26 Nov 2018 09:26

kreizo kreizo

Level 2

Posts: 2

Rate: 1
» | Topic author Helpful post? (+1)

Post #3
17586180 26 Nov 2018 09:26

Okay, but I have to calculate the average by the way, I forgot to add ?. So it is to calculate the average rating and by the way, if the cell is empty, it is to write "no ratings"
#4 17586274 26 Nov 2018 10:14

Prot Prot

Level 38

Posts: 2580

Help: 574

Rate: 297
» | Helpful post? (0)

Post #4
17586274 26 Nov 2018 10:14

I suggest a formula like in the screenshot
2018-11...png (12.54 kB)You must be logged in to download this attachment.
Create an account, log in here. You will receive points by participating in discussions.
Join this discussion.

Install Elektroda application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Perplexity AI, Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

Creating an IF Function in Excel to Display 'No Grades' in Empty Cells

Didn't find an answer? Ask Artificial Intelligence