View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CM CM is offline
external usenet poster
 
Posts: 136
Default Help with IF Statemet

I am trying to use an If(And) Statement and I keep getting "False" Returned

MY spreadsheet has 5 columns one is for names and one is for revenue. I want
to label Items Yes when
- certain names appear in a column,
- when other names appear in a column if the revenue associated with that
name is below a certain threshold. I have been using the following but it
keeps returning "False". Can you not use IF and If(And) in the same
statement? Or am I jjust writing it incorrectly?

I am using
=IF(A1="Bob","Yes",IF(A1="Simon","Yes",IF(AND(A1=" John",B1<131),"Yes","No")))

Any help would be well received

CM