Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Returning an amount or a minimum in a formula (2003 SP2)

    Good morning

    in one column I have a rate per mile of 1.03 in another column I have a mileage figure, what I would like to do is have the calculation return a minimum of 15 regardless of what the miles are, for clarity

    if the miles are 10 the real calculation is 10.30 but I would like to show 15.00
    if the miles are say 15 the calculation would be 15.45

    I have got it working by dividing 15.00 by the rate 1.03 which is 14.56 and inserting it into the formula =MAX(E2438 <font color=red>(miles)</font color=red> ,14.56)*Q2438 <font color=red>(rate per mile) </font color=red> but I can't help thinking that this is the wrong / long / ineffecient way to do this.

    Any thoughts please

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Returning an amount or a minimum in a formula (2003 SP2)

    You could use

    =MAX(E2438*Q2438,15)

    instead.

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Returning an amount or a minimum in a formula (2003 SP2)

    Thanks Hans

    Bang on the money - this way I don't get the awkward 14.99 etc. in some of the cells

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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