Function needed

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

fgwiii

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
 
Try this:

=If(And(C2="",D2<>""),"OK","Problem")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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
 
Back
Top