| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get string to use IF formula only when another cell is text
=IF(AND(ISTEXT(A1),B1=0),"x","")
"GoinCrazy" wrote: Hi all, Thanks for any suggestions, although I'm sure this is very simple, for anyone other than myself... If cell $A1 is text I want to use an IF formula. But if A1 is blank (or number) I want to return a blank cell as the result. ex: A B C 1 boy 0 x 2 hat 3 0 4 5 123 0 6 124 The formula I've tried (that doesn't work) is: =IF(ISTEXT(A1),(=if(B1=0,"x",""),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Formula to return a value for a portion of a text string in a cell | Excel Discussion (Misc queries) | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Return a formula as text string to a cell | Excel Worksheet Functions | |||
| Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
Threaded Mode
