Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'greater than' formula (Excel 97)

    I'm just learning formulas. This will probably be very simple for the majority but I am totally frustrated at this point in time. Been playing with this for over 30 min. I have a list of numbers that I need to calculate a cost on. If the number is 150 or less the cost will be $30. If the number is over 150 the cost will be $30.00 + $0.17 and the difference between number listed and 150. This is what I have but it is returning true or false. =IF(A1<150=30, IFA1>150-A1*0.07) Please help. Thanks in advance.

    Example follows:

    48 This should total $30.00 because it is less than 150
    193 This should total $37.31 because $30 for the 150 plus $7.31 for the additional 43.
    288
    235
    229
    239
    200
    167
    245
    220
    263
    183
    276
    171
    291
    229
    54

  2. #2
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'greater than' formula (Excel 97)

    Madam Butterfly,

    Try this:

    =IF(A1<150, 30, (A1-150)+30.17)

    is this what you need?

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'greater than' formula (Excel 97)

    I finally got the formula after another 30 minutes.
    =IF(K3<150,"30",IF(K3>150,((K3-150)*0.17)+30))
    Persistence pays off. Just knowing the Lounge is here helps with the stress levels. I know that help is not far away.

  4. #4
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'greater than' formula (Excel 97)

    FWIW, using your new formula, what happens if a1 = 150? try this.

    =if(a1>150,30+((a1-150)*0.17),30)

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'greater than' formula (Excel 97)

    Or:

    =30+(A2>150)*(A2-150)*0.17
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •