![]() Thank you very much spending your time to read this question, I hope to have an answer from one of you soon. I really don’t know what was missing, since the formula was working perfectly on google sheets, that’s why I come to here and post this question, and hope some genius can help me out. I found on the open office site, the error code 511 is:ĥ11 Missing variableğunction requires more variables than are provided, for example, AND() and OR(). Which is the same as before, but it all have the error code 511. However once I downloaded the file as OpenOffice ods file, it became like this: The formula under “Week 1” sheet, cell B4, is: I used google sheets to create this on the go before I download it onto the pharmacy computer, which they use LibreOffice. Then on another sheet “Week 1”, the patient name will appear under the desired location accordingly as follow: I am building a spreadsheet in use for our pharmacy, in which one sheet (Patients list) we put the patient names and details, such as the following: The file link is here (sorry I don’t have enough points to upload file yet) Hi, I am building a formula to match two criteria and have multiple results, based on the tutorial found from here:
0 Comments
Leave a Reply. |