Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get string to use IF formula only when another cell is text
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",""),"") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get string to use IF formula only when another cell is text
Try...
=IF(ISTEXT(A1),IF(B1<"",IF(B1=0,"x",""),""),"") Hope this helps! http://www.xl-central.com In article , 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",""),"") |
#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",""),"") |
Reply |
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) |