Formula to prevent the duplicated value

Mohammednt0
4StarLounger
Posts: 456
Joined: 05 Dec 2016, 13:48

Formula to prevent the duplicated value

Post by Mohammednt0 »

Image


as you can see we just finished balance for month 8,

but the formula is duplicating the month 8 (534360) value !

is there a way to return "-" instead of the duplicated month 8 value?

I use this formula =E21-L21+N19

please check the attached file
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78391
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Formula to prevent the duplicated value

Post by HansV »

Change the formula in M11 to

=IF(K11=0,0,E11-K11+M9)

Then copy to M13, M15, etc.
Best wishes,
Hans

Mohammednt0
4StarLounger
Posts: 456
Joined: 05 Dec 2016, 13:48

Re: Formula to prevent the duplicated value

Post by Mohammednt0 »

thanks it worked