Help with IF Statemet
The formula seems okay. Check that you have exact names in your data
and not any leading or trailing spaces. You might like to use TRIM(A1)
rather than A1 to get rid of them.
Hope this helps.
Pete
On Feb 2, 12:54*pm, CM wrote:
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
|