Formula

L

Link

Is there a formula to use if you want the answer Y or N in cells without
having to type it all the time for (example formatting the column so that if
I click the mouse twice Y comes up if I click once N comes up.
 
S

Shane Devenshire

Hi,

No formula but you can use vba in which case I would double-click to toggle
thru all three possibilities - Y, N, and blank. Will that work for you?
 
R

RagDyer

Since it seems that you want to stay away from the keyboard, why not create
a "Data Validation" drop down list, where there are only those two (Y - N )
choices?
 
L

Link

What is vba?

Shane Devenshire said:
Hi,

No formula but you can use vba in which case I would double-click to toggle
thru all three possibilities - Y, N, and blank. Will that work for you?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compute Additional Hours Needed Using "if" or "lookup" 1
Excel does not accept text format! 0
Use an "OR" around nested IF statements 2
match formula 2
Newbie Help - IF Yes No Function 0
Value of particular column 3
COUNTING TEXT VALUES GIVEN MORE THAN ONE ARGUMENT. 2
Logical formatting for multiple values 1

Top