View cells Empty when Reference Cells is Empty

[maabadi]

Hi
I have input these formulas in Columns But they Show results when the references cell is Empty
1. Column A : =COUNTIF($B$1:B197,B197)
2. Column C : =B199*1000+A199
3. Column G : =TEXT(WEEKDAY(F199),"dddd")
4. Column J : =I199-H199
5. Column L : =IF(AND(F199>=TotalReport!$C$1,F199<=StaffInformation!$E$1),1,"")
6. Column M : =TEXT(F199,"mmmm")
7. Column N : =F199-WEEKDAY(F199,2)-1

I want to them was Empty Until I Don't Fill Reference Cells.

How do I Improve Them?

Thanks
Maabadi

 

[Andrew Poulsom]

An example:

=IF(F199="","",F199-WEEKDAY(F199,2)-1)

 

[maabadi]

An example:

=IF(F199="","",F199-WEEKDAY(F199,2)-1)

Thanks and Good working