A | B | C | ||
1 | 2 | =2^a1/(2^a1+2^a2+2^a3) | ||
2 | 2 | |||
3 | ||||
<tbody>
</tbody>
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?