IF Formula

Dear,

i want solution for the below case,

i want to add Male/Female Automatically Based On Mr./Mrs/Ms By using IF formula.

like If 1st word of the cell = Mr. then Male

 

can you help me to do it in by using If formula?

By: siddeeque

Leave a Reply

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