Results 1 to 3 of 3

Invoice formula help to read zero if blank

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    Australia
    MS-Off Ver
    Excel 2011 - Mac
    Posts
    7

    Invoice formula help to read zero if blank

    Hi All,

    I'm putting together an invoice form that has columns for Part #, Description, Quantity, Each price and total with about 10 rows. The total column is a basic formula of Quantity multiplied by the Each price. Eg E2=C2*D2 Currently if the Quantity & Each price columns are blank the formula still puts a zero in the total column.

    Can anyone suggest a change to the formula so that the total column is blank if the Quantity & each price columns in that row are empty?

    Basically don't want a total column full of zero's.

    Thanks in advance for any help.

    Ray
    Last edited by RayBox; 09-01-2011 at 09:56 PM.

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