Forum Discussion
HELP with IF Formula
I am trying to create a formula that will look at four cells and depending on the condition, return a value from another four cells. If two or more cells are "Yes", I need to return "ERROR". Can anyo...
B9:B12 contains 4 cells, but B18:B22 contains 5 cells, so there's a problem...
I figured out the issue and worked around it. I added another row so I have equal number of cells. Cell B9 was asking if there was a curb or guardrail, simple YES or NO. If YES, return cell B19, NO returns cell B20 to B15. I added inserted a row so to ask "With curb?" and then "Without curb?". What you sent me works perfectly now. Thank you.