| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do if create IF functions using text as the logical test?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do if create IF functions using text as the logical test?
A1 = Joe
B1 = 10 =IF(A1="Joe","Yes, A1 equals Joe","No, A1 does not equal Joe") =IF(A1="Joe",B1*10,0) =IF(AND(A1="Joe",B1=10),"Winner","Try again") Biff "nellybean" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do if create IF functions using text as the logical test?
=IF(A1="string","text in A1","no text")
=IF(ISTEXT(A1),"text","no text") Either one will do. Gord Dibben MS Excel MVP On Thu, 7 Dec 2006 10:27:02 -0800, nellybean wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) | |||
| change text color based on logical test | Excel Worksheet Functions | |||
Linear Mode
