Home |
Search |
Today's Posts |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make a checked check box = 1 instead of True?
I've written a 6,000-line macro and I've used lots of formulas but I've
Just curious, you have a single macro with 6000 lines?!? Have you not heard of "structured programming"? =IF(H6="USD",80,5)+if(CheckBox512=True,1,0) Checkbox512?!? How in the world do you keep track of what checkbox does what? You didn't give them meaningful names? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "crimsonkng" wrote in message ... I hope that this is the correct group in which to post this question. I've written a 6,000-line macro and I've used lots of formulas but I've never worked with check boxes (until now). I don't want the Check Box's "cell link" to return True or False, I want it to return a value ... "1" if True and a "0" if False because I need to add it to another value. In other words, if the box is checked, add 1. If it's not checked, add 0 as in: =IF(H6="USD",80,5)+if(CheckBox512=True,1,0) So, I want the formula to return 80, 81, 5, or 6 depending upon the values of H6 and Check Box 512. But I get a #NAME! error. I've tried it with and without quotes and various other combinations of punctuation but nothing works. I guess I just don't know the correct syntax of the formula when using Check Boxes. Excel Help doesn't provide an answer and I can't find it on the web. Thanks, in advance, for your help. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
How can I check if any of the entires is True in a range? | Excel Worksheet Functions | |||
Do I have to make my times be numbers to get a true average? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Hiding cells on condition | Excel Worksheet Functions |