+ Reply to Thread
Results 1 to 6 of 6

formula problem based on answer

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    formula problem based on answer

    Hi guys

    what i need to do is
    in cell p45 i need it to return these answers based on whats in cell p49

    so if p49 is between 0.00 and 25,000 then cell p45 should return 29
    if cell p49 is between 25,001 and 50,000 then cell p45 should return 58

    but if cell p49 is between 50,001 and 200,000 then it needs to return 0.5% of that value
    all help gratefully received

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,356

    Re: formula problem based on answer

    Try
    =IF(P49<=25000,29,IF(P49<=50000,58,0.005*P49))

    No check on upper limit of 200,000: what if it is > 200,000 ???

  3. #3
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: formula problem based on answer

    Hi John

    I will cross that bridge as and when but the true reality is that its unlikely to happen for now.
    Thank you so so much

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,356

    Re: formula problem based on answer

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: formula problem based on answer

    Hello, You can use this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  6. #6
    Registered User
    Join Date
    04-11-2016
    Location
    Daventry, England
    MS-Off Ver
    2016
    Posts
    24

    Re: formula problem based on answer

    Hi

    I think this covers all your options:
    =IF(P49>200000,"Unknown",IF(P49>50000,P49*0.05,IF(P49>25000,58, IF(P49>=0,29, IF(P49<0,"Unknown"))))).

    Regards
    Alan

+ 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] On formula answer if a 0 (zero) answer, must be blank
    By Colin Smitie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2017, 06:43 AM
  2. [SOLVED] Formula to give a yes/no answer based on chart
    By Tarontagosh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2017, 10:49 AM
  3. Replies: 7
    Last Post: 03-23-2015, 03:24 PM
  4. [SOLVED] copy cells based on answer to formula
    By luckymusictron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2014, 12:06 PM
  5. Replies: 2
    Last Post: 03-20-2014, 07:12 AM
  6. Replies: 7
    Last Post: 12-14-2010, 05:38 PM
  7. answer:formula problem
    By soprano1115 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-14-2010, 06:20 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