Remember Me?

#1
March 5th 07, 06:22 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 2
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
March 5th 07, 06:35 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 27
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%?

#3
March 5th 07, 06:36 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 698
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%?

#4
March 5th 07, 06:39 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 964
Maximum value in a cell

Use the MIN function.

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%?

#5
March 5th 07, 08:13 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 2
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%?

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Session101 Excel Worksheet Functions 1 April 12th 06 09:06 PM sharkfoot Excel Discussion (Misc queries) 3 March 6th 06 12:08 AM Rachael Excel Discussion (Misc queries) 12 January 25th 06 06:46 PM Malisky Excel Discussion (Misc queries) 1 January 12th 06 02:33 PM Frank Drost Excel Discussion (Misc queries) 8 November 22nd 05 05:45 AM

All times are GMT +1. The time now is 02:13 PM.