First, a formula can only return a value to that cell that holds the function.

So you'd have to put this in U37:
=if(a37<true,"",375)

But I don't see how this fits in your Total amount????




MarthaSue wrote:

Hi Dave, thanks for the quick response. I am still having trouble, please
forgive me, as I am learning as I go. When i am trying to do the cell link, I
am getting an error
"The text you entered is not a valid reference or defined name".

I wrote =if(a37<true,"",then(U37=$375.00). If the box is checked then I
want Excel to enter the dollar amount (375.00) in the total amount. I am
creating an electronic ticket. Please let me know if you can help me. I
appreciate your time,
Sharlene

"Dave Peterson" wrote:

Show the Forms toolbar (View|toolbars|Forms)

You'll see a checkbox on that toolbar.
Click on it and draw your checkbox in the cell you want.
Now right click on that checkbox and select Format Control
Then on the Control Tab, assign a nice Cell link (I'll use A1).
(if you protect that sheet, make sure that cell link is unlocked.)

Now use a formula that checks the value in that cell link:

=if(a1<true,"",sum(b:b))
(don't put this formula in Column B--or adjust the range:
=if(a1<true,"",sum(b2:B9999))



MarthaSue wrote:

I would like to create a check mark box in my excel document so that I can
click on it and a check mark will appear. I would then like to create a
formula that would add a dollar amount in the total column if the checkmark
is present. Could someone please let me know how I can go about doing this?

--

Dave Peterson


--

Dave Peterson