Checkboxes

E

Es

I want to insert a checkbox in a spread sheet that if
checked it multiplies a cell D5 with 1.71 and if uncheced
the same cell multiplied by 1.35
Thanx
 
D

Dave Peterson

Put a nice checkbox from the Forms toolbar on your worksheet.
Give it a nice Linked cell.
Rightclick on it
Format Control|Control tab
Cell Link (say A1)

Then use a formula:
=d5*(if(a1=true,1.71,1.35))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking at alternatives 1
constant multiplier 4
same cell multiplied by set value 1
Conditional Formatting 2
Checkboxes in cells 2
costing values 8
Rounding up or down 4
Protecting "linked cells" 1

Top