| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
manipulating cells with symbols and numbers
Does anyone know if I can do this...
I have a column of values that I would like to find the average of, but some of the cells contain numbers with a < in front of them. The average should use 1/2 the value of the numbers with < in front of them. Thanks in advance for your help! Colleen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting numbers | Excel Discussion (Misc queries) | |||
| can't change the alignment of numbers in cells | Excel Discussion (Misc queries) | |||
| sort alphabebically ignoring preceeding symbols or numbers | Excel Worksheet Functions | |||
| Numbers instead of symbols on scatter chart | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
