He will think of possible contexts in your sheets where much more functionality will be implemented. For one advising here, this is not a way easily to go. We may accept that as we sometimes also may eat a bad Burger. If the guesses were correct there remains as a matter of fact that the above solution is of rather low quality. (How the value 4 should be handled still only guessed.) Whether it is likely or not that this might implement your intentions will depend, among other things, on the question whether or not you admit non-integer values for B3. so if you ever want to know something about woodworking just let me know and i will give you all the practical answers you need unless you are interested in becomming a real woodworker, then i would also refer you to practice exercises and tutorials.Ĭode: Select all =IF(AND(0<=4) "1T" IF(AND(4<=6) "2T" IF(AND(6<=9) "3T" IF(AND(9<=12) "4T" "Inadmissible value!")))) so functional code is greatly appreciated and i am greatfull for comunities like this existing where knowledge is passed on and help is provided and i can tell you that i do so in my field of expertise. i just needed this job to be done to get back to my workshop. i am not interested in learning all that there is to learn about open office calc. I mentioned in a different thread that i am a woodworker and just have one very specific goal in mind: make some invoicing system for myself now that i switched to ubuntu, as on the internet i have not found what i needed. i made the effort to read your tutorials and made the formula work.nevertheless, i would have preferred in this case a direct solution such as a correction of my code, which i understand was a very simple thing. Thanks for your help and i am am aware that my questions are beginners questions. For example, the last section in the tutorial gives an example of using multiple conditions in a formula. Beginner questions are fine in the forum, but it will save you considerable time to get these concepts straight instead of asking for help every day. Reread each day until you understand the material. Read Ten concepts that every Calc user should know if you have not. MrProgrammer wrote:You have been asking lots of very common questions for beginners.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |