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

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

Can an expert assist please

Thanks

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")

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

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

not maybe Rgonzo. That works. Thanks

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.

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

But thanks for trying

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

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

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