If coloumns L+N has values, I need to get an average of these, and if possible add "/10" at the end if the cell is filled out. I have tried for hours and either get an error or /10 written in the blank cells. The result in the screenshot is not desirable either as the formula doesn't account for blank cells such as L3.
My current formula is:
=IFS((L3+N3)/2=0;"";(L3+N3)/2;(L3+N3)/2)
Screenshot 2022-01-13 at 18.48.30.png
I managed to get the /10, but can't for the life of me figure out how to get rid of it if no values are in the coloumns L+N:
=IF((L27+N27)/2=0;"";(L27+N27)/2)&"/10"
Screenshot 2022-01-13 at 18.57.33.png
Any help is greatly appreciated!
Bookmarks