Results 1 to 4 of 4

Please help with IF Formula - want to make cell blank if no text in another cell

Threaded View

  1. 08-01-2013, 04:38 AM #1
    nayahh
    nayahh is offline
    Registered User
    Join Date
    08-01-2013
    Location
    New South Wales, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Please help with IF Formula - want to make cell blank if no text in another cell

    Hi everyone.
    I have a worksheet with two tabs in it.
    One is 'Product list' the other 'Order form'
    I have linked the two worksheets using a lookup function so that when i enter a code into cell A9 the following fields will display the details of that product.
    I want to insert a function so as cells B9, C9 and E9 show a blank cell if no product code is enetered.

    I have attached the worksheet.
    If anyone can help it would be greatly appreciated.IA_Country Fair Product List.xlsx
    Last edited by nayahh; 08-01-2013 at 04:51 AM. Reason: Comply with rule 1
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for Deleting a Formula when the Formula has done its Calculation
    By Sam_D in forum Excel General
    Replies: 6
    Last Post: 10-08-2009, 03:45 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1