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.
2 Comments - Last post 28 minutes ago by wigglenose
312 Comments - Last post 53 minutes ago by Gamy7
126 Comments - Last post 3 hours ago by pb1
18 Comments - Last post 3 hours ago by pb1
5 Comments - Last post 4 hours ago by BattleChaing
2,626 Comments - Last post 6 hours ago by MeguminShiro
39 Comments - Last post 10 hours ago by Nekrux
1,490 Comments - Last post 2 minutes ago by Taurus9534
10,078 Comments - Last post 5 minutes ago by IronKnightAquila
41 Comments - Last post 11 minutes ago by wiLLie22
446 Comments - Last post 36 minutes ago by Nickbread
109 Comments - Last post 49 minutes ago by RiderOfPhoenix
377 Comments - Last post 50 minutes ago by DrTenma
161 Comments - Last post 51 minutes ago by Patxxv
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.