| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, OR, AND function
I am trying to do an IF function with either AND or OR, and so far it is not
given me the right answer, please help. If the first letter of cell A1 is 1 or D, then blank, or else +A1 =IF(OR(LEFT(A1,1)="D",VALUE(LEFT(A1=1),"",A1)) Ania Ziolkowska 2006-01 DayTotal 1/17/2006 DayTotal 1/16/2006 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF, OR, AND function
=IF(OR(LEFT(A1,1)="D",VALUE(LEFT(A1))=1),"",A1)
This should return A1, but if you need a numeric result, you've still got some work to do... "Thuy" wrote: I am trying to do an IF function with either AND or OR, and so far it is not given me the right answer, please help. If the first letter of cell A1 is 1 or D, then blank, or else +A1 =IF(OR(LEFT(A1,1)="D",VALUE(LEFT(A1=1),"",A1)) Ania Ziolkowska 2006-01 DayTotal 1/17/2006 DayTotal 1/16/2006 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
