Ian Bell
asked on
And OR formula
Hi,
I'm trying to do what should be a simple formula.
Please see attached. I have placed the formula results in column A
Please place formula in A col.
Thanks
Ian
-AND-OR.xlsx
I'm trying to do what should be a simple formula.
Please see attached. I have placed the formula results in column A
Please place formula in A col.
Thanks
Ian
-AND-OR.xlsx
ASKER
Cells A5:A6 result should be 1 as B5 or B6 are not equal to A1
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Shums, perfect. I had the same formula as you had first sent, then got lost :)
Cheers
Ian
Cheers
Ian
You're Welcome Ian! Glad I was able to help.
Please try below:
Open in new window