Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spell number | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |