Posted to microsoft.public.excel.worksheet.functions

fgwiii[_2_] fgwiii[_2_] is offline

external usenet poster

Posts: 36

Function needed

Good morning,

I am trying to identify records in which 'Start Date' is null and/ the
'Unknown or -30 days' field Checked. I tried using a If statement, but I
received errors each time.
=if((C2 IS NULL) AND (D2 ="Checked"),[Ok], [Problem])

Start Date Unknown or -30 days
20071017 Not Checked
20071017 Not Checked

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help needed with function	[email protected]	Excel Worksheet Functions	1	September 12th 08 12:20 PM
Help needed with function	Kevin	Excel Worksheet Functions	2	January 28th 06 06:29 AM
Function Help Needed	Harvey Gersin	Excel Worksheet Functions	4	November 29th 05 11:01 PM
Needed help with if function	manasi	Excel Worksheet Functions	2	September 20th 05 07:05 PM
Help needed with IF function	Ed	Excel Worksheet Functions	1	March 23rd 05 04:26 PM

All times are GMT +1. The time now is 08:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us