Make cells invisible until they are populated

Hi,

Couple questions regarding the uploaded sheet below
I'm trying to create an accounting document, but stuck in couple fields

1) Make balance appear in column E5 only if column C5 OR D5 is polulated, so goes for the rest of the cell in that colu
2) I like to have 2 digits after the decimal but (same as above) i want it to appear ONLY if there are any decimals to that number, all those 0 become confusing.
3) I need to make it so the last calculated cell on sheet Jan of column E gets transfered auto to sheet Feb D3 of F3 so the calculations could proceed to the next month

Thanks for the help

test1.xlsx

Try this in E5 and copy down (and up)

PHP Code: 

=IF(OR(D5<>"",C5<>""),SUM(E4-C5+D5),"") 


Awesome, Thanks

That code cleared my problem #1 : )

1 down 2 more to go : )

For #2 are you trying to show $5.00 as $5 (ie remove hte zeros) but $5.20 as $5.20 or as $5.2?

$5.00 as $5 and
$5.20 as $5.20

test1(2).xlsx

Try the attached. It carries forward the balance from January to February.

I haven't come to terms with your second request though. I personally like all my decimal points aligned. If you go through with this the numbers will be all over the place BUT if that's what you want I'll give it some thought. I'm not sure how you have different formating set up based on the value without writing some VBA which you probably don't want.

on 2nd thought you're right. Think I'll leave it as is.
Seeing all the repetitions on the balance column made me confusing, but your formula for #1 resolved that issue. So I think it'll be good if i leave it this way.

As for #3, works like a charm.
Thanks again for the help.
How do i turn this thread to solved? I saw the option when i was opening it.

Glad it worked OK. I think only the OP can mark a thread as solved. Can't recall how or where you do this though

Sounds good. We'll leave it to them then.

Hope i can return the favor one day.

Cheers

You're the OP - Original poster. I thought there was a button that only you can see to mark as solved. I'm sure someone else will point you in the right direction

thought u meant Operator, as in Admin.
Will look it up

found it, upper right corner in the drop down of "Thread Tools"