+ Reply to Thread
Results 1 to 3 of 3

Help solving plus and minus for linens

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    7

    Help solving plus and minus for linens

    Hi! Im a newbie here as well as on excel formulas, can anyone help me on solvin?
    i need the BASE subtracted whenever the Hotel 1 and 2 adds number and when the soiled comes back it will be deducted on the hotel 1 and 2 and it will detect loses..

    sorry for my english..

    Thank You.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Help solving plus and minus for linens

    It is not clear exactly what you want but here is what I think.

    Base is the total inventory.
    Hotel 1 and Hotel 2 are the counts of clean items that have been sent to each of those locations.
    Laundry Soiled is the count of soiled linens that come back from Hotel 1 and Hotel 2 (combined).
    On-Site is inventory still on site that has not been sent out.
    Losses, therefore, is the count of what has gone out to the hotels minus what has come back soiled. That is Hotel 1 + Hotel 2 - Laundry Soiled. The formula for that is
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-17-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    7

    Re: Help solving plus and minus for linens

    yes you got it right.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Swits leading minus and put minus infront of numbers without macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2015, 11:40 AM
  2. [SOLVED] How to get the correct (minus) answer for a minus raised to a power
    By enginezzz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 08:44 PM
  3. [SOLVED] I neeed help on changing a minus figure so it does not show a minus
    By Kirstg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2012, 11:44 AM
  4. Replies: 6
    Last Post: 12-09-2007, 11:09 AM
  5. Solving as x?
    By gpktm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2007, 12:42 AM
  6. [SOLVED] CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
    By Socal Analyst looking for help in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 02:20 PM
  7. how do you count a column minus dupicates minus blanks.
    By notEXCELing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2005, 08:48 PM

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