+ Reply to Thread
Results 1 to 8 of 8

'Return a value based on the value of another cell'

  1. 11-30-2011, 07:45 AM #1
    megan7775
    megan7775 is offline
    Registered User
    Join Date
    05-20-2011
    Location
    Leeds
    MS-Off Ver
    Excel 2002
    Posts
    10

    'Return a value based on the value of another cell'

    Hi, thanks for looking,

    I need a formula to do the following – I don’t think its that difficult I just don’t know the full formula.

    If the value in cell C is less than £999.99 bring back £40 OR of the value in cell C is between £1000 & £9,999.99 bring back £70 OR if the value in cell C is £10,000 or above bring back £100.

    Can you help me please?

    Many thanks

    Megan
    Last edited by megan7775; 11-30-2011 at 10:17 AM.
    Reply With QuoteRegister To Reply
  2. 11-30-2011, 07:51 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: formula help

    Hi Megan.

    Try this:

    Please Login or Register  to view this content.

    Regards
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 11-30-2011, 07:51 AM #3
    brokenbiscuits
    brokenbiscuits is offline
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: formula help

    =if(C1<1000,40,if(C1<10000,70,if(C1=0,0,100)))

    But please take a few minutes to read the forum rules, particularly Rule 1.
    Reply With QuoteRegister To Reply
  4. 11-30-2011, 08:35 AM #4
    megan7775
    megan7775 is offline
    Registered User
    Join Date
    05-20-2011
    Location
    Leeds
    MS-Off Ver
    Excel 2002
    Posts
    10

    Re: formula help

    Quote Originally Posted by brokenbiscuits View Post
    =if(C1<1000,40,if(C1<10000,70,if(C1=0,0,100)))

    But please take a few minutes to read the forum rules, particularly Rule 1.
    Hi Thank you for your help,

    I have just read rule 1 and see that my subject line wasn;t acceptable - out of couriosity what should I have used as my subject line?
    Reply With QuoteRegister To Reply
  5. 11-30-2011, 08:40 AM #5
    brokenbiscuits
    brokenbiscuits is offline
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: formula help

    Something along the lines of
    'Return a value based on the value of another cell'
    'Calculating Commission'
    etc.

    There's no real right or wrong answer, just something descriptive that relates to your particular problem, rather than 'Formula Help', which could be one of a million things. That way, if someone else comes along with a similar problem, and they search for terms that match your title, they'll find the answer without having to post another question.
    Reply With QuoteRegister To Reply
  6. 11-30-2011, 09:26 AM #6
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: formula help

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  7. 11-30-2011, 10:18 AM #7
    megan7775
    megan7775 is offline
    Registered User
    Join Date
    05-20-2011
    Location
    Leeds
    MS-Off Ver
    Excel 2002
    Posts
    10

    Re: formula help

    Many thanks ive changed it now.

    Have a nice day
    Reply With QuoteRegister To Reply
  8. 11-30-2011, 10:19 AM #8
    megan7775
    megan7775 is offline
    Registered User
    Join Date
    05-20-2011
    Location
    Leeds
    MS-Off Ver
    Excel 2002
    Posts
    10

    Re: formula help

    Hi Roy

    I have changed it now,

    Many thanks
    Megan
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1