View original (French)

Empty cell if = cell above

Solved
alex23160 Posted messages 58 Registration date   Status Member Last intervention   -  
alex23160 Posted messages 58 Registration date   Status Member Last intervention   -
Hello,

I would like to create a very succinct account tracking table in Excel.
I have created an automatic formula that allows me to only enter the values of my expenses and my income, and Excel calculates my total (see attached image):

http://image.noelshack.com/fichiers/2015/53/1451294056-excel-compte-1.png

Following that, I copied the formula by dragging the cell down, and I get this:

http://image.noelshack.com/fichiers/2015/53/1451294202-excel-compte-2.png

Everything is normal.

Now, I would like the cell (in the "remaining" column) that is equal to the cell above to be empty (or colored white with white text) to avoid having the same cell multiple times in a row.

If you have a tip, I would appreciate it.

Thank you :)

Configuration: Windows 7 / Chrome 47.0.2526.106

2 answers

Answer 1 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   834
 
Hello

You can use a formula with controls

=IF(AND(E6="",F6=""),"", $G$5+SUM($E$5:E6)-SUM($F$5:F6))

--
It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes.
1
alex23160 Posted messages 58 Registration date   Status Member Last intervention  
 
Hello,

thank you for the response, by copying the formula letter by letter I get the desired result.

Could you explain how the formula works please?
I would like to use it again in other spreadsheets.
0
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   834 > alex23160 Posted messages 58 Registration date   Status Member Last intervention  
 
We check if E6 and F6 are empty, and in that case, we write nothing, hence the ""
Then we take the starting value in G5 + the sum of the exits in column E - the sum in column F.
0