software

Hi there,

I have a need to enter a formula to limit the size of a number displayed in
a cell.

For example H19 is set to display the sum of H39

Now H39 could be any number from 0 to 100 but I want to limit the size of
the number displayed in H19 to a maximum of 20 - even if H39 is displaying
100

I want H19 to reflect the true value from 0 to 20 and just display a maximum
of 20 despite the fact that H39 could possibly display any number up to 100

--
Thanks amp; regards,
-pp-
Hi

=MIN(H39,20)--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )quot;Pheasant Plucker®quot; gt; wrote in message
...
gt; Hi there,
gt;
gt; I have a need to enter a formula to limit the size of a number displayed
gt; in
gt; a cell.
gt;
gt; For example H19 is set to display the sum of H39
gt;
gt; Now H39 could be any number from 0 to 100 but I want to limit the size of
gt; the number displayed in H19 to a maximum of 20 - even if H39 is displaying
gt; 100
gt;
gt; I want H19 to reflect the true value from 0 to 20 and just display a
gt; maximum
gt; of 20 despite the fact that H39 could possibly display any number up to
gt; 100
gt;
gt; --
gt; Thanks amp; regards,
gt; -pp-
gt;
gt;
Try
=MIN(H39,20)

quot;Pheasant Plucker®quot; wrote:

gt; Hi there,
gt;
gt; I have a need to enter a formula to limit the size of a number displayed in
gt; a cell.
gt;
gt; For example H19 is set to display the sum of H39
gt;
gt; Now H39 could be any number from 0 to 100 but I want to limit the size of
gt; the number displayed in H19 to a maximum of 20 - even if H39 is displaying
gt; 100
gt;
gt; I want H19 to reflect the true value from 0 to 20 and just display a maximum
gt; of 20 despite the fact that H39 could possibly display any number up to 100
gt;
gt; --
gt; Thanks amp; regards,
gt; -pp-
gt;
gt;
gt;

It really is that easy - when you know how of course! ;^)

Thanks for the replies guys.

Kind regards,
-=pp=-

quot;Philip J Smithquot; gt; wrote in message
...
gt; Try
gt; =MIN(H39,20)
gt;
gt; quot;Pheasant Plucker®quot; wrote:
gt;
gt; gt; Hi there,
gt; gt;
gt; gt; I have a need to enter a formula to limit the size of a number displayed
in
gt; gt; a cell.
gt; gt;
gt; gt; For example H19 is set to display the sum of H39
gt; gt;
gt; gt; Now H39 could be any number from 0 to 100 but I want to limit the size
of
gt; gt; the number displayed in H19 to a maximum of 20 - even if H39 is
displaying
gt; gt; 100
gt; gt;
gt; gt; I want H19 to reflect the true value from 0 to 20 and just display a
maximum
gt; gt; of 20 despite the fact that H39 could possibly display any number up to
100
gt; gt;
gt; gt; --
gt; gt; Thanks amp; regards,
gt; gt; -pp-
gt; gt;
gt; gt;
gt; gt;