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%? |
Answer: Maximum value in a cell
Setting a Maximum Value in a Cell Using a Formula in Microsoft Excel
|
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%? |
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%? |
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%? |
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%? |
All times are GMT +1. The time now is 04:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com