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 Download (12.54 kB)

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

Reply | New topic

#1 17585724 25 Nov 2018 22:15

kreizo kreizo

Level 2

» |

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

» | 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

» | 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

» | Helpful post? (0)

Post #4
17586274 26 Nov 2018 10:14

I suggest a formula like in the screenshot
2018-11...png Download (12.54 kB)
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi 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