Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a graphic to a worksheet as a result of If/Then Statemet | Excel Worksheet Functions |