Link to home
Start Free TrialLog in
Avatar of Jagwarman
Jagwarman

asked on

help with formula

I am trying to say

IF B2 =0, "Complete", "Incomplete", OR IF B2>=0 and B10=1,"Complete","Incomplete"

Can an expert assist please

Thanks
Avatar of Phillip Burton
Phillip Burton
Are these two separate formulas? i.e.

IF(B2 =0, "Complete", "Incomplete")

IF (and(B2>=0,B10=1),"Complete","Incomplete")

If not, then I don't understand, because if B2=0, then it will never get to the second part of the code.
Avatar of Jagwarman
Jagwarman

ASKER

so you are saying it is not possible then to say

IF(B2 =0, "Complete", "Incomplete")  or  IF (and(B2>=0,B10=1),"Complete","Incomplete")
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jagwarman
Jagwarman

ASKER

not maybe Rgonzo. That works. Thanks
Avatar of Phillip Burton
Phillip Burton
I'm saying it is not possible for something to be both Complete and Incomplete. It appears that your first bit of your formula could say Incomplete, but your second says Complete.
Avatar of Jagwarman
Jagwarman

ASKER

Hi Phillip that was my thought to when I was asked to help. But what they are doing is logical and Rgonzo's result works for me

But thanks for trying