Results 1 to 3 of 3

Using Multiple If statements in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Bangor
    MS-Off Ver
    Excel 2003
    Posts
    12

    Using Multiple If statements in a cell

    Help!!!!!!
    Please could someone give me a pointer.
    I want a cell to take away a set amount if a different cell from a range has the letter "S" in it. If more than one cell has "S" in it I want it to take away a further amount. I can get it to work with just one "S" in any of the boxes from the range but it wont work with more than one. The formula I have at the minute is:
    =SUM(Sheet1!B5:F5,IF(Sheet1!B6="S",-6,IF(Sheet1!C6="S",-7.5,IF(Sheet1!D6="S",-7.5,IF(Sheet1!E6="S",-7.5,IF(Sheet1!F6="S",-7.5,IF(Sheet1!B6="UH",-6)))))))
    Last edited by Guygettinby; 10-13-2011 at 12:51 PM. Reason: Monitor told me to

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1