I want to find out if I can craft and formula that checks a number of cells and returns a named condition, e.g. IF(A1=0, IF B1=0, IF C1=0, IF D1=0,"Active","-") ?
I want to find out if I can craft and formula that checks a number of cells and returns a named condition, e.g. IF(A1=0, IF B1=0, IF C1=0, IF D1=0,"Active","-") ?
Hi jrmac,
Welcome to the forum.
You can with the AND/OR function. Like the below
If you want all conditions to be met then use the AND FunctionIf you want any1 condition to be met then use the OR Function![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Thanks,
Bonny Tycoon
**If I was able to help please click the small star icon at the bottom left of my post **
Last edited by bonny24tycoon; 05-28-2012 at 01:57 PM.
Excellent. I have been searching for a few years for the answer and this is first time I have recieved on that worked! Thanks Bonnie.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks