Results 1 to 2 of 2

Need help with a formula that has 3 conditions

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2005
    MS-Off Ver
    Office 2010
    Posts
    37

    Need help with a formula that has 3 conditions

    I am requesting help with a formula that I am flubbing.

    In the enclosed file I need a formula in col D that will return the following:

    Col D to return how many items still needed to ship to achieve 90% of the value in col B after subtracting what has already shipped (col C).

    If Col B is zero then I just need 90% of col A.

    If Col B already exceeds the value of 90% of col A I need to return the qty exceeded perhaps in brackets.

    And then if qty to ship = zero, then just zero.

    I hope this makes sense.

    Thank you

    Book1.xls
    Last edited by kcleere; 06-23-2013 at 06:30 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