If check box value true then yes else no

**HaroonSid** · 03-07-2018, 12:48 PM

Hi,
I created a check box on sheet 1
I want to do a formula
Like this
If(checkbox1.value=true,"yes","no")
Using a check box value in simple formula

Thank you

**JohnTopley** · 03-07-2018, 12:55 PM

Right click on the check box==>format Control==>cell Link

in cell link assign any cell (say A1)

then formula is

=IF(A1,"Yes","No")

If check box value true then yes else no

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

If check box value true then yes else no

Re: If check box value true then yes else no

Thread Information

Users Browsing this Thread

Similar Threads

Check for Multiple TRUE in a spreadsheet

[SOLVED] I am trying to check if two values are true

Check box when ticked returns value of True instead of 1

check box when its true

Macro to check range, if false check another range until true, then copy

[SOLVED] check box - true/false/na

[SOLVED] check for IsEmpty(MyArray) = True

Bookmarks

Bookmarks

Posting Permissions