Results 1 to 4 of 4

Returning a $ value if a checkbox return true

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Returning a $ value if a checkbox return true

    Hello All,

    I am trying to set up an Excel formula that calculates a $ value if a checkbox returns true or false.

    Basically, if the checkbox is checked, the COST amount needs to be multiplied by the QTY value. I've attached a screen shot of the basic table.

    Right now I have a basic SUM working using: =SUM(COST*QTY) but I need to include a checkbox if statement I believe. I've tried everything but can't get it to work.

    Can anyone help? I'm sure it's very simple.
    Attached Images Attached Images

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