+ Reply to Thread
Results 1 to 2 of 2

Formula required to hide results from another cell formula

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003 and Excel 2007
    Posts
    3

    Formula required to hide results from another cell formula

    Hi all

    Wonder if someone more clued up with Excel can help me please?

    I've got a spreadsheet that has 2 worksheets (Requests and Quantity). In the Quantity sheet, I've got the following formula in cell d12

    =C12-Requests!C11

    This takes a stock level figure from c12 and minuses it from cell c11 in the Requests tab. Then in cell e12, I've got the following:

    =D12-Requests!D11

    This then runs on for a few more rows. Is there a way in the Requests tab, I can get the cells c12, d12 and so on to be blank and not show the result from the previous cell?

    Many thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Formula required to hide results from another cell formula

    If all you are trying to do is hide the intermediate calculations, just put the formulas in the same column in an unused area to the right and hide that column.
    Ben Van Johnson

+ 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