Formula to prevent the duplicated value
-
- 4StarLounger
- Posts: 456
- Joined: 05 Dec 2016, 13:48
Formula to prevent the duplicated value
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.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula to prevent the duplicated value
Change the formula in M11 to
=IF(K11=0,0,E11-K11+M9)
Then copy to M13, M15, etc.
=IF(K11=0,0,E11-K11+M9)
Then copy to M13, M15, etc.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 456
- Joined: 05 Dec 2016, 13:48
Re: Formula to prevent the duplicated value
thanks it worked