Formula to limit the size of a number result in a cell?
 

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 & regards,
-pp-

Formula to limit the size of a number result in a cell?
 

Hi

=MIN(H39,20)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Pheasant Plucker®" wrote in message
...
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 & regards,
-pp-

Formula to limit the size of a number result in a cell?
 

Try
=MIN(H39,20)

"Pheasant Plucker®" wrote:

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 & regards,
-pp-

Formula to limit the size of a number result in a cell?
 

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

Thanks for the replies guys.

Kind regards,
-=pp=-

"Philip J Smith" wrote in message
...
Try
=MIN(H39,20)

"Pheasant Plucker®" wrote:

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 & regards,
-pp-