u/theendisnigh91

Hey all. I am brand new to this and teaching myself. I want to preset a column to see if a set of other cells have a number in them. If not, I want it to act as if they are zero. If they do have any numbers, I want it to round the average of the numbers. So far the formula I’ve come up with is

=IF(ISBLANK(D4:M4),"0", ROUND(AVERAGE(D4:M4),0)

I know this isn’t right and doesn’t work. I just don’t know what I’m messing up. Any and all advice would be greatly appreciated!

Edit: I think u/whonose2238 fixed it! Thank you all for your help!!!

“There is a second issue: ISBLANK(D4:M4) is checking a range, which can produce an array of TRUE/FALSE values rather than simply asking whether the whole range is blank.

If what you mean is “if all cells D4:M4 are blank, return 0; otherwise average the populated cells and round to a whole number”, I'd use:

=IF(COUNTA(D4:M4)=0, 0, ROUND(AVERAGE(D4:M4),0)) “

I was talking to my wife about pronouns and when people have multiple and she brought up an opinion that had never occurred to me. When someone uses multiple pronouns such as She/They or He/She I was under the impression that it was like a list of monikers and you ,as the person talking to or about them, were welcome to use any of them. She brought up a different idea. She’s says that generally you should be using all of them in the sense that you jump around from one to another in a conversation. Her reasoning for this was because to only use one, especially the gender assigned to them at birth, is to place them back into the binary even if they fit outside it. Can anyone shed some light on this? Is this generally what’s expected? I hate to think I’ve been messing it up all this time!