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

1. ## 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.

Cheers

Steve

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

You could use

=MAX(E2438*Q2438,15)

3. ## 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

#### Posting Permissions

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