+ Reply to Thread
Results 1 to 5 of 5

Formula when clicking Check Box

  1. #1
    Registered User
    Join Date
    02-11-2012
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2007
    Posts
    3

    Formula when clicking Check Box

    Hi Guys, I am new to this site and I would be very grateful if anyone can help me with this problem I am having, I have spent hours and as yet not resolved it.

    I have a Check Box in a cell and I want the check box to do the following.

    If the check box is ticked I want 2 cells to be multiplied together and another amount added to the answer.

    If the check box is not ticked I only want the 2 cells to be multiplied.

    Thank you anyone for your input, I am sure the answer is fairly simple and I will kick myself when I get the answer.

    kindest regards
    Steve

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula when clicking Check Box

    Welcome to the forum.

    Assuming you mean a forms checkbox on a worksheet, the linked cell is either true or false. Use that in your IF formula.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-11-2012
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula when clicking Check Box

    Hi shg, many thanks for your reply, with lots of tries and web searching I was abel to get cells to show or hide text and if the check boxes were ticked or not get other cells to give different results.

    once again, many thanks

    Steve

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula when clicking Check Box

    Assuming that means you got it sorted, you're welcome.

  5. #5
    Registered User
    Join Date
    02-11-2012
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula when clicking Check Box

    All sorted and looking very good, although I say it myself, lol.

    Once again many thanks
    Steve

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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