Community Wishlist
Search for new games to share.
Guidelines
Community rules and guidelines.
FAQ
Frequently asked questions.
Comment Formatting
Syntax for writing comments.
want to earn some money by downloading apps? Fill this form
Nope but thanks for the giveaway
Comment has been collapsed.
np
Thank you very much! :)
Nested IFs containing nested ANDs can be confusing. This is what you want:
=IF(D13<67,"neprospěl",IF(AND(D13>66,D13<77),"prospěl",IF(AND(D13>76,D13<87),"dobře",IF(AND(D13>86,D13<97),"chvalitebně",IF(AND(D13>96,D13<107),"výborně","")))))
If D13>106 the formula returns blank text ""
With your ranges, the formula would return an error if D13=60-66, so I changed the numbers a bit.
It was only homework to school nad works,so i will keep that.Thanks for help so much,buddy! :)
I did it as u describe.Its right,but teacher dont want it this way.So,he is idiot.Thanks,anyway.
84 Comments - Last post 51 minutes ago by ChrisKutcher
16,299 Comments - Last post 3 hours ago by Carenard
56 Comments - Last post 10 hours ago by Carenard
1,811 Comments - Last post 11 hours ago by ngoclong19
72 Comments - Last post 13 hours ago by Reidor
545 Comments - Last post 15 hours ago by UltraMaster
41 Comments - Last post 15 hours ago by ViToos
119 Comments - Last post 59 seconds ago by Norbee001
56 Comments - Last post 1 minute ago by SilentGuy
14 Comments - Last post 3 minutes ago by PonBaron
73 Comments - Last post 6 minutes ago by Thedarksid3r
9 Comments - Last post 10 minutes ago by PonBaron
21 Comments - Last post 11 minutes ago by PonBaron
97 Comments - Last post 17 minutes ago by PonBaron
Nope but thanks for the giveaway
Comment has been collapsed.
np
Comment has been collapsed.
Thank you very much! :)
Comment has been collapsed.
Nested IFs containing nested ANDs can be confusing. This is what you want:
=IF(D13<67,"neprospěl",IF(AND(D13>66,D13<77),"prospěl",IF(AND(D13>76,D13<87),"dobře",IF(AND(D13>86,D13<97),"chvalitebně",IF(AND(D13>96,D13<107),"výborně","")))))
If D13>106 the formula returns blank text ""
With your ranges, the formula would return an error if D13=60-66, so I changed the numbers a bit.
Comment has been collapsed.
It was only homework to school nad works,so i will keep that.Thanks for help so much,buddy! :)
Comment has been collapsed.
I did it as u describe.Its right,but teacher dont want it this way.So,he is idiot.Thanks,anyway.
Comment has been collapsed.