Results 1 to 4 of 4

cell shows value because the formula is not been complete

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2010
    Location
    hull
    MS-Off Ver
    Excel 2003
    Posts
    8

    cell shows value because the formula is not been complete

    ive got a setup where a you pick a item in cells A and in cells B it shows the price they then type the quantity of the item in cell C. And in Cell D i Have e.g. B1*C2 and its shows Value When no item selected but because of the way i need it to work is there some formatting etc that i can use to get it to put "£0" if no item is selected


    thanks for your time

    Josh
    Last edited by palmer19; 06-13-2010 at 10:50 AM.

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