If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Maximum value in a cell
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Maximum value in a cell

#1
March 5th 07, 05:22 PM posted to microsoft.public.excel.misc
 Tareeka external usenet poster 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, 05:35 PM posted to microsoft.public.excel.misc
 external usenet poster 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/C1>1,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, 05:36 PM posted to microsoft.public.excel.misc
 Ron Coderre external usenet poster 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, 05:39 PM posted to microsoft.public.excel.misc
 Elkar external usenet poster 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, 07:13 PM posted to microsoft.public.excel.misc
 Tareeka external usenet poster 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/C1>1,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 Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Address of Maximum value in Cell Session101 Excel Worksheet Functions 1 April 12th 06 09:06 PM Maximum and minimum cell value sharkfoot Excel Discussion (Misc queries) 3 March 5th 06 11:08 PM Maximum data in cell Rachael Excel Discussion (Misc queries) 12 January 25th 06 05:46 PM Which the maximum of characters of value in a cell? Malisky Excel Discussion (Misc queries) 1 January 12th 06 01:33 PM format cell with maximum value Frank Drost Excel Discussion (Misc queries) 8 November 22nd 05 04:45 AM

All times are GMT +1. The time now is 09:33 PM.