+ Reply to Thread
Results 1 to 3 of 3

First time adding a check mark. Adding check mark to make one cell toggle between 2 formul

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    10

    First time adding a check mark. Adding check mark to make one cell toggle between 2 formul

    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!
    Attached Images Attached Images
    Last edited by sw0226; 10-28-2013 at 01:18 PM.

  2. #2
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: First time adding a check mark. Adding check mark to make one cell toggle between 2 fo

    Link the tickbox to cell L28 then put this formula in cell J28
    =IF(L28=TRUE,H24+K24,H24)


    Windy

  3. #3
    Registered User
    Join Date
    10-28-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: First time adding a check mark. Adding check mark to make one cell toggle between 2 fo

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Putting a check mark in a cell
    By Turtleman10 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-15-2013, 02:40 PM
  2. Excel: How do I type a letter in a column and make a check mark a.
    By BauerY in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-15-2012, 11:46 PM
  3. Enter a check mark into a cell
    By jsfowler in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-11-2011, 04:25 PM
  4. [SOLVED] How do I make a check mark?
    By kentrks in forum Excel General
    Replies: 2
    Last Post: 09-07-2005, 09:05 PM
  5. Adding a Check Mark commant to the Menu
    By TimlmiT in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1