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