Forum Discussion
If one of multiple cells contain specific text then return value
I am stumped on work project. I have a cell F13 intended to be dependent on a range of 4 other cells. When all cells are No, I just need F13 to stay blank. So far this works. Range F5, F7...
I think an OR condition would capture the cases you need while ignoring the FALSE arising from the intervening blank cells.
= IF( OR(statusColF = "Not effective"), "Not effective", "")If you needed to remove the blanks, that is straightforward with 365 and the array shaping functions WRAPROWS and TAKE.
Thank you
With everything my boss keeps adding and subtracting form our chart I keep having to change formulas. Thank you.
Some things are easier with array formula and Lambdas; others you just have to bite the bullet and get in there with a knife and fork. The times Lambda wins out are when a single change in the Lambda propagates throughout the workbook. If every formula is a one off then it gains you little and can even increase your problems.
- I completly agree or in my case a sledgehammer and grit.
My other obstacle is when my boss wants things to look or work a certain way then I have to articulate this is a template, or don't just look at the paint job let me create the date first then we will put out a sheet for use later, after the date is tested for use.
The more wants create problems and sometimes I have to compensate or get creative.
