column question

[pete3716]

Hi,

Sorry for asking a newbie question but I can not find the answer anywhere. So please have patience.

The other day I decided to fix up a worksheet for my personal finance. So I have Debits and Credits. At the far right is my Total.
Say column F is for Total. So I put in the equation and dragged the cell all the way down. This worked well and the calculation
was correct. The correct dollar was displayed on F3. And the same dollar amount also displayed on F4, F5, F6...... all the way down.
I found that a bit disturbing to look at and wondered what can be done to eliminate that same repetitive displays on F4,F5.... .

Thanks for your help!

[NeedForExcel]

As far as I can think, there was a problem with Absolute/Mixed/Relative Cell References in the Formula..

Can you mention what your formula was?

[ufopilot]

Does your formula contain the "$"? This will keep the cell static: Dragging "$F3" Down will change the formula to "$F4, $F5, $F6....", on the other hand: Dragging "$F$3" Down will change the formula to "$F$3, $F$3, $F$3.....because you set the code to row 3 by using the "$"-sign

[samba_ravi]

Use if function
=if(count(d4:e4),"use formula what you are using now","")
still you are facing problem, provide the formula which you are using in F2 or F3

[pete3716]

I don't have the dollar sign on equation. I just have "=F2-C3+D3" and dragging it down the column.

[samba_ravi]

Try the following in F3
=IF(COUNT(C2:D2),F1-C2+D2,"")
OR
=IF(COUNT(C2:D2),LOOKUP(10^10,F$1:F1)-C2+D2,"")
COPY TOWARDS DOWN

[pete3716]

Thanks nflsales the first equation worked for me. Now I have only one outcome displayed. Great! Many thanks!