Closed Thread
Results 1 to 2 of 2

Office 365

  1. #1
    Registered User
    Join Date
    07-02-2016
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    2

    Office 365

    Hi i am trying to work out a formula that will allow me to get an answer dependant on certain criteria
    e.g. if the sum of a cell is more than 0 but less than 300 will answer 40, more than 301 but less than 400 will answer 30, and more than 401 but less than 500 will give 20
    Any ideas??

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Office 365

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-new-...4-formula.html

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Moving from Office 2003 to Office 2013 - code no longer works
    By GeorgeC47 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2014, 11:20 AM
  2. Open PDf specific page, work with office 2007 but not on office 2013
    By haktak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 01:58 AM
  3. Workbook VBA Project Reference will not migrate form Office 2010 to Office 2002
    By DAve Bradbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2013, 07:43 AM
  4. Replies: 4
    Last Post: 05-02-2010, 12:05 PM
  5. [SOLVED] Performance not upto Office 2003 standards in Office 2007
    By Mangal Singh in forum Excel General
    Replies: 11
    Last Post: 05-29-2006, 08:00 PM
  6. [SOLVED] Merging excel office data into a publisher office project(Australi
    By Shirl in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-16-2006, 04:20 AM
  7. Replies: 2
    Last Post: 03-21-2006, 06:00 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