Link to home
Create AccountLog in
Avatar of 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

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


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")
Avatar of Rgonzo1971

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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.
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