Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JROD
 
Posts: n/a
Default I want to return a value based on the status of a check box. If .

I want the return a value based on the status of a check box or radio button.
If checked = true then 1 else 0
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

If you're using a checkbox from the Forms toolbar, right-click the
checkbox and choose Format Control...

In the control tab, enter a cell reference (e.g., Z1) in the Cell Link
field. That cell will return TRUE/FALSE. In your target cell, enter

=--Z1

which coerces the boolean TRUE/FALSE to 1/0.



In article ,
"JROD" wrote:

I want the return a value based on the status of a check box or radio button.
If checked = true then 1 else 0

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to return a value based on a whether a number is within a ra. laurieevan Excel Worksheet Functions 3 February 24th 05 12:14 PM
I want to return "0" based on another cell CM Excel Worksheet Functions 2 February 17th 05 03:46 PM
formula to return the value of a cell based on a looked up true reference sarah Excel Worksheet Functions 2 February 2nd 05 09:15 PM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 10:59 AM
Can VLOOKUP return multiple answers based on several identical lo. jddtct Excel Worksheet Functions 3 January 11th 05 08:03 AM


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"