| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to insert checkboxes in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| Checkboxes | Excel Discussion (Misc queries) | |||
| How do I use checkboxes correctly? | Excel Discussion (Misc queries) | |||
| resize control checkbox with cell | Excel Discussion (Misc queries) | |||
Linear Mode
