I would appreciate if you can please advise:
I need help in coding a function with "=(IF(AND(OR" etc.
I am sure that this topic was discussed previously but I don't know what to fill in the search bar to get any results.
I'm afraid something like that can be pretty hard to search for. I believe part of the problem is that 'and' and 'or' are considered keywords for the search.
One thing you could try would be doing a Google search of the site, but I don't think that would return quite what you're looking for either.
Since Aladdin's approach does not seem to be what you are looking for, if you are able to spell out all of your criteria in that thread accurately it may be easier to see what can be done.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.