Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lower than question
I work at a lab, and when we get results that our equipment can not measure
the samples, we use the "<" symbol with the number. My question is, how can i get Excel to add the "<" symbol to a result if any of the cells has a number with the "<" symbol. 2 3 4 The average of these numbers is 3.0. But if one of the numbers has the "<" symbol, the formula result needs to hae the "<" also in the result: <2 3 4 The result should read <3.0 All i need is excel to add "<" to the result if any of the numbers in the colum has that "<" symbol. Including the number with "<" in the equation Any sugestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If lower, highlight | Excel Worksheet Functions | |||
Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
One more formula question--adding LOWER | Excel Discussion (Misc queries) | |||
How to get to lower right corner | Excel Discussion (Misc queries) | |||
First Lower Case | Excel Worksheet Functions |