+ Reply to Thread
Results 1 to 4 of 4

How do I create a formula for calculating multiple invoice type items

  1. #1
    Registered User
    Join Date
    05-10-2006
    Location
    Afghanistan
    MS-Off Ver
    7
    Posts
    8

    How do I create a formula for calculating multiple invoice type items

    I cannot figure the formula that will allow me to sell products without the length and width in the line. I need to sell bulk products without dimensional sizes.

    I do not want zeros to show on the invoice unless inputted.

    This is the formual in the total column:

    =IF(SUM(V8)>0,SUM((R8*T8)*V8)-Z8,"")


    Please Help
    Attached Files Attached Files
    Last edited by MGMRAM; 07-10-2008 at 12:34 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

    Think Google.

  3. #3
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day

    When you have formula looking at a cell with other formula, in my experience the formula must return a value. The quotation mark ("") to represent blank does not work.

    So I've told the formula to return a value of zero. Because you do not want the value of zero showing I have apply a 'Conditional Formatting' to the required cells. 'Format only cells that contain' rule and formatted the font white.

    Please PM a Forum Mod to change the thread title. Thanks.

    Post back or PM if more questions needed to be answered.

    Hope this help
    Attached Files Attached Files
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  4. #4
    Registered User
    Join Date
    05-10-2006
    Location
    Afghanistan
    MS-Off Ver
    7
    Posts
    8

    Smile

    This looks as if will work exactly as I hoped to. Your expertise is greatly appreciated!!

    Thank you

+ 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