Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum value in a cell
I am trying to set a maximum value in a cell. I have a percentage calculated
in one cell, from time to time the precentage is greater than 100%. Is it possible to set the formula to only allow a maximum of 100%? |
#2
|
|||
|
|||
Answer: Maximum value in a cell
Setting a Maximum Value in a Cell Using a Formula in Microsoft Excel
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum value in a cell
You didn't give the formula in the cell currently, so let's say it's:
=B1/C1 If you change this formula to =IF(B1/C11,1,B1/C1) you should get what you need. = Marchand = On Mar 5, 9:22 am, Tareeka wrote: I am trying to set a maximum value in a cell. I have a percentage calculated in one cell, from time to time the precentage is greater than 100%. Is it possible to set the formula to only allow a maximum of 100%? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum value in a cell
Maybe something like this:
A1: (a number) B1: (a percent) This formula multiplies the value in A1 by the lesser of the B1 Percent OR 100% C1: =A1*MIN(B1,100%) Does that help? *********** Regards, Ron XL2002, WinXP "Tareeka" wrote: I am trying to set a maximum value in a cell. I have a percentage calculated in one cell, from time to time the precentage is greater than 100%. Is it possible to set the formula to only allow a maximum of 100%? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum value in a cell
Use the MIN function.
=MIN(your formula, 100%) This returns whichever value is lower between "your formula" and 100%. HTH, Elkar "Tareeka" wrote: I am trying to set a maximum value in a cell. I have a percentage calculated in one cell, from time to time the precentage is greater than 100%. Is it possible to set the formula to only allow a maximum of 100%? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum value in a cell
THANK YOU, this is it!! You have no idea how long I have been trying to
figure this out!! " wrote: You didn't give the formula in the cell currently, so let's say it's: =B1/C1 If you change this formula to =IF(B1/C11,1,B1/C1) you should get what you need. = Marchand = On Mar 5, 9:22 am, Tareeka wrote: I am trying to set a maximum value in a cell. I have a percentage calculated in one cell, from time to time the precentage is greater than 100%. Is it possible to set the formula to only allow a maximum of 100%? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Address of Maximum value in Cell | Excel Worksheet Functions | |||
Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
Maximum data in cell | Excel Discussion (Misc queries) | |||
Which the maximum of characters of value in a cell? | Excel Discussion (Misc queries) | |||
format cell with maximum value | Excel Discussion (Misc queries) |