Can any 1 help me with my excel plz?

[HAz]

Any pro can help me with the sums on my sheet!
I did a course on this about 10 years ago and ive forgotten most of what i learn .

Heres the link to it http://www.filefront.com/15454173/hazexcel.rar


Basically i want to add tick boxes to 2 colums. If both boxes are tick it will give the output in the "money made" cell.

Please help me

 

[Pho]

You need to enable the developer toolbar, it's all explained here. You'll have to use the cell link to then link the value of the checkbox to the cell which it's over (i.e. you place the checkbox in G9 and so you need to link the checkbox to G9).

Do you have to use checkboxes? They're somewhat of a nightmare for what you're planning to do.

Personally I'd just format all 'cleaned' and 'collected' cells as numeric then go to 'Data' > 'Data Validation' > 'Data Validation' and set it to 'Whole Number' between 0 and 1 instead to ensure people can only enter in those values.

Your 'Money Made' formula is then just:
=IF(G9+H9=2, E9, 0)