I’m trying to run what I thought would be a simple formula, but I can’t seem to figure it out.
Basically, I want this formula in one cell to check that all 5 cells in a range (unnamed so far) have anything in them (Numbers in this specific case), and as long as all of them have data, output a number. I’m not looking for a sum, but just that any number is in each of those 5 other fields to satisfy the criteria to output a specific number in a 6th field.
I don’t want a sum
Thought this would be simple enough, but I probably am using the wrong formula. Any help would be greatly appreciated.
