Formula help

[Sblais]

I have a spreadsheet with these formulas in the columns:

Column A Column B
=IF(Month!A2<>"",Month!A2,"") =IF(A16>0,C6,"")

A2 on my "Month" worksheet is currently blank, but column B (on another worksheet) still shows the amount in C6.

I want it to be when a date in entered on the Month worksheet, which would be entered in A2, Column B (on the other worksheet) then shows the amount in C6. If A2 on my Month worksheet is blank, then C6 should be blank until a date is entered. Right now, column B shows the amount in C6 whether A2 on the Month worksheet is blank or has a date in it. See the picture added.

What am I doing wrong?

 

[Fluff]

As A16 has a formula you need to use

=IF(A16<>"",C6,"")

 

[Sblais]

That works great! Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.