Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How might I create an IF formula to recognize whether text in a column is
lower or upper case so that the text-related values may be added or subtracted based on the case of the text? For example, I have text in B1:B50 whose complimenting values I would like to + or - from the values attributed to the text in D1:D50 depending on the case of that text. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Code | Excel Discussion (Misc queries) | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
Spellnumber | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |