# Minimum and maximum

1. ## Minimum and maximum

Can you help me,

I wish to make a formula for example B2*B3 but I want to lower out come as 1 and no higher as 5.

How can I do this?

Kind Regards.

2. ## Re: Minimum and maximum

Hi Ikke,

I don't understand what you mean - please give more detail.

David

3. ## Re: Minimum and maximum

here, use this:

Formula:
`Please Login or Register  to view this content.`

4. ## Re: Minimum and maximum

David,

Maybe like this it's more clear:
B2 is a formula of 2 dates > June 10 - June 6 = 4
each day i want 0,5 so the calculation is = 4*0,5=2
But when the calculation = 1*0,5=0,5 i want a minimum of 1,
or when the calculation = 13*0,5= 6,5 i want a maximum of 5.

does that make any sense?

5. ## Re: Minimum and maximum

Hi there... and welcome to the Excel Forum. Use this:

=MIN(MAX(1,B2*B3),5)

6. ## Re: Minimum and maximum

Guess who forgot to refresh before posting??? I'm still half asleep!!

7. ## Re: Minimum and maximum

Thanks, I won't add to zbor or Glenn

8. ## Re: Minimum and maximum

Dear All,

Thank you for welcome me, and help me fixing the first formula.

How can i confirm that i have the answer?

9. ## Re: Minimum and maximum

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)