So I have this formula which also takes into consideration empty cells (a3) for future entries.
Formula is very simple but works only if I include non-empty cells to that equation.
As you can see above a3 is empty (I want excel to calculate it once I put another number there).
Correct answer to this should be 0.5 but somehow excel tells me its 0.444
2/(2+2) = 0.5
So to my understanding excel is using logic empty cell = 0 therefore 2^0 =1 which then indeed equals 0.444
is there a way to tell excel to treat empty cells as empty instead of 0?