rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
Been extending a formula
Initially I had
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
Initially I had
VBA Code:
=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
VBA Code:
=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)))