Excel table wrong formula repeating

Hi, I have started working on a new sheet on excel for my hotel to manage my incomes and outcomes, and I have managed most of the formula's, but I have a little annoying problem with one of my table ...

excel

Riny_van_Eekelen
Dec 21, 2021
ESHREF98 Change the formula in E4 to =C4-D4+N(D3) or =SUM(C4,-D4,D3)
Either will work. The N function allows you to refer a cell containing a text in a regular arithmetic calculation (i.e. + - / * ). Without the N that would cause an error. In your case, N3 contains a text and it is simply "translated" to a zero value. SUM ignores text by default and does not return an error if you happen to include a text in the sum range(s).

Riny_van_Eekelen

Platinum Contributor

Dec 21, 2021

ESHREF98 Change the formula in E4 to =C4-D4+N(D3) or =SUM(C4,-D4,D3)

Either will work. The N function allows you to refer a cell containing a text in a regular arithmetic calculation (i.e. + - / * ). Without the N that would cause an error. In your case, N3 contains a text and it is simply "translated" to a zero value. SUM ignores text by default and does not return an error if you happen to include a text in the sum range(s).

ESHREF98
Copper Contributor
Dec 21, 2021
thanks for the reply, it helped me alot.

Forum Discussion

Excel table wrong formula repeating

Resources