issues with formula

[rhombus4]

Been extending a formula

Initially I had

=IF(OR(AND(A1 = "Cat", B1 <> ""),AND(A1 = "Dog", B1 <> "")),B1-C1,"")

Tried to extend to below for certain results in the formula but not sure how to get the first part to workas if its not cat or dog It results in False

=IF(OR(AND(A1="Cat",B1<>""),AND(A1="Dog",B1<>"")),IF(B1-C1>10,"Over 30 days",IF(B1-C1<-10,"10 Days Passed",B1-C1)))

 

[Sufiyan97]

W

Been extending a formula

Initially I had

=IF(OR(AND(A1 = "Cat", B1 <> ""),AND(A1 = "Dog", B1 <> "")),B1-C1,"")

Tried to extend to below for certain results in the formula but not sure how to get the first part to workas if its not cat or dog It results in False

=IF(OR(AND(A1="Cat",B1<>""),AND(A1="Dog",B1<>"")),IF(B1-C1>10,"Over 30 days",IF(B1-C1<-10,"10 Days Passed",B1-C1)))

What you want as result if its not cat or dog?

 

[Fluff]

Maybe

=IF(B1="","",IF(OR(A1={"Cat","Dog"}),IF(B1-C1>10,"Over 30 days",IF(B1-C1<-10,"10 Days Passed",B1-C1)),""))

 

[rhombus4]

Maybe

=IF(B1="","",IF(OR(A1={"Cat","Dog"}),IF(B1-C1>10,"Over 30 days",IF(B1-C1<-10,"10 Days Passed",B1-C1)),""))

A Durfani I forgot to add, needed a blank if not cat or dog

Thanks Fluff

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Sufiyan97]

A Durfani I forgot to add, needed a blank if not cat or dog

Thanks Fluff

No problem,

Glad you got the solution..