Bill Golden
asked on
Reverse the logic of an existing Excel formula
I am using the following formula in Conditional Format rule
=IF(P5="B",IF(OR(ISNUMBER( SEARCH("A" ,H5)),ISNU MBER(SEARC H("T",H5)) )*AND(J5>1 ),CEILING( SUM(C5-B5) ,"0:15"),) ,"0:00")
I want to reverse the logic
=IF(P5="B",IF(OR(ISNUMBER(
I want to reverse the logic
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER