checkbox for formula
If E7 is returning TRUE or FALSE, you could change your formula to
=IF(E7,IF(AND(ISBLANK(F7),ISBLANK(G7)),"",H6-F7+G7),"")
or
=IF(AND(E7,COUNT(F7:G7)),H6-F7+G7,"")
--
David Biddulph
"B." wrote in message
...
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.
|