A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Maximum value in a cell



 
 
Thread Tools Display Modes
  #1  
Old March 5th 07, 05:22 PM posted to microsoft.public.excel.misc
Tareeka
external usenet poster
 
Posts: 2
Default 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%?
Ads
  #2  
Old March 5th 07, 05:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default 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  
Old March 5th 07, 05:36 PM posted to microsoft.public.excel.misc
Ron Coderre
external usenet poster
 
Posts: 698
Default 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  
Old March 5th 07, 05:39 PM posted to microsoft.public.excel.misc
Elkar
external usenet poster
 
Posts: 964
Default 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%?

  #5  
Old March 5th 07, 07:13 PM posted to microsoft.public.excel.misc
Tareeka
external usenet poster
 
Posts: 2
Default 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

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

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 10:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.