Checkboxes
 

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

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))




Es wrote:

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

--

Dave Peterson