Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a rather complicated scenario that I need to resolve and I am hoping
that someone can guide me. I need to take a range of numbers in a column (could be positive or negative numbers) and convert the last digit of only the negative numbers in the column. The last digit will be converted to a character based on a series of values associated with the last digit. The values are as follows: p = 0, q = -1, r = -2, s= -3, t = -4, u = -5, v = -6, w = -7, x = -8, and y = -9. For example, the number -11523.64 would actually need to read 11523.6t (because it's a negative number, the last digit is replaced with a "t" which is -4's value). Conversly, if the number were 11523.64, then the number would remain exactly as it appears as a positive 11523.64. Any assistance would be greatly appreciated. -- J Harris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
Complex Vlookup and List Validation and Nested IF statements | Excel Worksheet Functions | |||
HELP? nested, complex, vlookup? The impossible! | Excel Worksheet Functions | |||
nested if(and) functions | Excel Discussion (Misc queries) | |||
Limited IF Nested Level functions. | Excel Discussion (Misc queries) |