| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy one..not for me..
I'm trying to have a cell simply input "YES" or "NO" when you type a "Y" or a
"N"... HELP! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy one..not for me..
This assumes you placing Y or N in cell a1, copy the line below to the cell
you want YES or No to appear, it cant be the same cell as A1. =IF(A1="y","Yes",IF(A1="n","No","")) Alter the a1 to what ever cell you want to look at. -- This post was created using recycled electrons! "Rogie" wrote: I'm trying to have a cell simply input "YES" or "NO" when you type a "Y" or a "N"... HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Should be a easy How do I | New Users to Excel | |||
| easy | Excel Worksheet Functions | |||
| Probably easy but I need help! | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Probably Easy for you!! | Excel Discussion (Misc queries) | |||
Linear Mode
