Hiding values in cells
I have one cell that has my begining total...and then another cell that has
the payment and the 3rd cell is the remaining balance my formula is =SUM(D2,-C3) then i copied all the totals down until the balance is zero when i enter in a payment then it subtracts and records the new balance but the new balance shows up in all the cells below.....How do i get the new balance not show up in all the cells after i enter a payment??? Here is a copy of my sheet C colum D colum Balance: $150.00 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 |
Hiding values in cells
Something like in your balance column:
=If(c3=0,"",Sum(d2,-c3)) I.e. if payment is zero (blank) , balance column is blank, otherwise show balance. HTH "Boomer" wrote: I have one cell that has my begining total...and then another cell that has the payment and the 3rd cell is the remaining balance my formula is =SUM(D2,-C3) then i copied all the totals down until the balance is zero when i enter in a payment then it subtracts and records the new balance but the new balance shows up in all the cells below.....How do i get the new balance not show up in all the cells after i enter a payment??? Here is a copy of my sheet C colum D colum Balance: $150.00 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 $3,010 |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com