=IF(Sheet1!A1="Y",B2,0)

  • Thread starter Thread starter Cuba
  • Start date Start date
C

Cuba

Using the above function in a spreadsheet. Want to avoid
using "Y & N" as values. Would prefer to use a Check Box
or Option Button. Is this possible?
 
Can you suggest a way to do this? Maybe how to select
the radio button and have that populate a value in a
field that can then be utilized by the formula / function?
 
Hi
you can link a optionbutton or a checkbox to a cell. Just open the
properties of this element and enter a cell reference for 'Linked cell'
 
How about a little cheating?

Format the range (whole column??) with a wingdings font.

Then format|Cells|Number tab|Custom
type alt-0252 ; alt-0252 ; alt-0252 ; alt-0252
(Hold down the alt and use the number keys from the numeric keypad--not above
QWERTY)

It should look something like:
ü;ü;ü;ü
(u with umlauts)

Anything you type will be formatted to show a checkmark.

There are other checkmarks available, too.
Take a look at Windows Start button|Run|charmap
Pick out the one you like and notice the keystroke combination in the lower
right corner.

If you want to check to see if that cell has been checked, you can:
=if(a1="","Nope","Yep")
(since anything will cause the checkmark to appear.)

If you wanted to count them up, you could do:
=COUNTIF(A1:A99,"*")
or
=COUNTIF(A1:A99,"<>")
 
Back
Top