I'm working on an Excel problem I'm having. I'm creating a receipt program so that when people buy things at my store their name comes up on the receipt thanking them. I have a database of names and every name is connected to a specific gender M or F. Basically how do I tell excel to change M into "Mr." or if it is F to "Mrs."
Thanks for the help.
2007-09-15 05:07:31 · 4 answers · asked by 123 1 in Computers & Internet ➔ Programming & Design
Instead of having a "gender" columns, have a "title" column, then it just lifts Mr or Mrs/Miss/Mz as appropriate
2007-09-15 05:16:35 · answer #1 · answered by stu_the_kilted_scot 7 · 0⤊ 1⤋
Male and Female are great for tracking target buyers in the future, but very poor for tracking Mr., Mrs.
What about Ms. or Miss. What about titles(if your business is related to this)Dr. DDR. PHd etc.
You could drop the Mrs. and just put Ms. in which case it would be inclusive but not exclusive. An if() statement would work here with concatenation down the road.
2007-09-15 14:40:41 · answer #2 · answered by Frank Pytel 4 · 0⤊ 0⤋
Use a lookup table or the IF function.
2007-09-15 12:15:51 · answer #3 · answered by Anonymous · 1⤊ 0⤋
=if(cell="M","Mr.","Mrs."). Then concantenate that with their name.
2007-09-15 12:15:55 · answer #4 · answered by Russ B 2 · 0⤊ 1⤋