LinkBack URL
About LinkBacks
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.
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.
Hi Ikke,
I don't understand what you mean - please give more detail.
David
here, use this:
Formula:
Please Login or Register to view this content.
Never use Merged Cells in Excel
David,
thank you for your replay.
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?
Hi there... and welcome to the Excel Forum. Use this:
=MIN(MAX(1,B2*B3),5)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Guess who forgot to refresh before posting??? I'm still half asleep!!
Thanks, I won't add to zbor or Glenn
Dear All,
Thank you for welcome me, and help me fixing the first formula.
How can i confirm that i have the answer?
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)
Posting Permissions
Register To Reply
Bookmarks