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.
76 Comments - Last post 10 minutes ago by Sundance85
45 Comments - Last post 29 minutes ago by reigifts
23 Comments - Last post 37 minutes ago by Thedogma
116 Comments - Last post 2 hours ago by TheMuzo
38 Comments - Last post 2 hours ago by fernandopa
16 Comments - Last post 2 hours ago by Gramis
124 Comments - Last post 3 hours ago by Reidor
3,712 Comments - Last post 47 seconds ago by pizurk
41 Comments - Last post 7 minutes ago by jimmy09172000
11,037 Comments - Last post 8 minutes ago by Swordoffury
157 Comments - Last post 14 minutes ago by GreyF0xx
1,007 Comments - Last post 26 minutes ago by Lugum
18 Comments - Last post 34 minutes ago by gus09
17,414 Comments - Last post 38 minutes ago by MjrPITA
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.