Hello, First time trying to add a check box to control a formula. I have 1 workbook with 9 sheets in it each sheet needs this checkbox added. This is for sheet 3 of 9, and when I do ad the check boxes I will do the sheets in order. One check box per sheet. I added the Form Control check box (also is there a way to change the font size for the text attached to the check box???)
Currently Cell J28 = H24 + K24.
I added the check box and would like make it so that when the check box is checked, than J28 = H24 + K24, like above,
but if it is not checked, than J28 = H24 only
The point is so that 2011 information can still be filled in to accurately reflect the self employed annual income for 2011, but not include it in monthly average because only 2012 monthly average is desired. The bottom number will be the number used to reflect a borrowers qualifying income for loan purposes... Sometime a 2 year average is desired. at times only 1 year, but would still like to show how they did in 2011...
Any help getting this done would be much appreciated. thank you!
Bookmarks