| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
checkbox for formula
Hi Folks,
I have a worksheet with basic formulas for addition and subtraction. For example; when I put the number on G7 it subtracts from H6 and shows the result on H7. I am using this formula on H7 =IF(AND(ISBLANK(F7),ISBLANK(G7)),"",H6-F7+G7) Now I would like to place a checkbox or radio button on E7 to control calculation on H7. If it is checked the calculation will be happened if not there will be no calculation. I am using Excel 2007. I spent my last 5 hours for this but no avail. Any help will be appreciated. Thanks, B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
| i want to base a formula off whether a checkbox is filled in | Excel Discussion (Misc queries) | |||
| Excel Checkbox can be regconized in a formula and be executed | Excel Worksheet Functions | |||
| check a checkbox in a formula | Excel Worksheet Functions | |||
| checkbox | Excel Worksheet Functions | |||
Threaded Mode
