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 FunctionPlease 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