Hi to all forum members.
I have on my excel sheet an Arabic column and I would like that if this column is not empty, that this student has a total greater than or equal to 155 so that it is admitted otherwise failure.
if the Arabic column is empty, it must have a total greater than or equal to 150 for it to be admitted, otherwise it fails.
Thanks for your help.
résultat.xlsx
Last edited by ANASSE; 05-22-2022 at 03:47 PM. Reason: send the sheet
Try this:
Formula:
Please Login or Register to view this content.
It's not the only way to do it but I prefer logic that only shows each possible result once.
Change 10 to whatever is the actual first row of data and fill down.
Next time attach your actual file and we can update your file for you. See yellow banner at the top of the page.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
It did not work
It works now, I replaced the commas with semicolons.
Thank you for your help
Hello ANASSE. Welcome to the forum. Glad to hear you have a solution.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Dave
Done and thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks