New Ms Excel Formula



This formula will work in all the version of Excel, if you run my macro. This formula takes two argument, 1st one is the ref of Name cell and 2nd one is ref of Gender column, then it will add Mr. if the gender is Male else it will add Ms.

Leave a Reply

Your email address will not be published. Required fields are marked *