| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I correct error using the =IF(AND(formula in excel?
Hello, can you help?
I would like to correct the following formula...This is what I have... =IF(B1:B4,"=01/01/06"),THENCOUNT,(C1:C4,IF=A1)) This is what my worksheet shows..... Column A Column B Column C Column D A 12/20/05 A (Above Formula)..This should=2 B 12/21/05 C C 01/03/06 A D 01/21/06 A Can you please help me in how to write the formula correctly??? Thanks so much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Is it possible to export the (Excel) auto correct "dictionary" to. | Excel Discussion (Misc queries) | |||
Threaded Mode
