| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
L14=total, if P14="text", L14=0
Hi,
I need to understand how to manipulate text in formulas. My problem is that if I have an... amount biger than zero in (L14) whose formula is =+J14-I14-K14, and should I then type in text in P14, L14 will then return a zero, instea of calculating =+J14-I14-K14 due to text typed in P14. The manipulation will have to occur in L14 (my totals column for th day) eg. L14 calculates total (=+J14-I14-K14), but if I type "any text" i P14, L14 = 0 Help will be most appreciated -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
L14=total, if P14="text", L14=0
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| =TEXT(L9-K9,"h:mm") How can I sum the results to a total value | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
![sonar[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
