Forum Discussion
James818
Aug 15, 2023Brass Contributor
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...
James818
Aug 15, 2023Brass Contributor
Thank you
With everything my boss keeps adding and subtracting form our chart I keep having to change formulas. Thank you.
PeterBartholomew1
Aug 15, 2023Silver Contributor
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.
- James818Aug 17, 2023Brass ContributorI 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.