View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robb27 Robb27 is offline
external usenet poster
 
Posts: 27
Default checkbox calculation

I would like to have a checkbox perform an if calculation. For instance if a
checkbox is checked then I would like it to look to multiple columns to the
right and if in the next column to the right has a checkbox checked then add
a number that is at the bottom of the column. I am using both control toolbox
checkboxes and forms toolboxes. (i could use one other other if that's what I
need to do)
Im going to checkmark the chkbox in column d, if there is a chkmark in colum
e then add $399. to the total, if there is a chkmark in the checkbox in the
cell to the right (f) then add 399. to that total too. ect. ect.

a b c d e
f g
1st name last name registered paid class 1 class 2
ect ----
chkbox chkbox
chkbox chkbox


Cost of tuition Total (?) $399.00
$399.00 $279.00

Thanks for looking at this for me.

Rob