Hide cells until I type something in another cell

[Barohata]

Hey there, I'm new in using Excel, and I'm working on my work sheet where I will save my entire hours and salary.
Anyway currently I'm working as a waiter, and I created the following excel file:
ba9877c436027d12496b3106e2990c9c.png
I've typed 2 days of work for example.

The formula on the Hours is:
=(((C2+D2)-(A2+B2))*24)-0.5
the 0.5 is because i get a 30 minutes break every day which I don't get paid for.
And the one on the salary is:
=160+(23*(F2-7.5))
because my base salary is 160 for 7.5 hours, and i get 23 for each hour after that.

Anyway, I formatted the whole column like that.
How can I change the formula so it will only apply when I typed information into the row?

Thank you in advance

[Richard Buttrey]

Hi and welcome to the forum

Unfortunately pictures are rarely much use to us and we require actual workbooks (see guidance in rules area). Upload a workbook and no doubt more answers will be forthcoming.

[Barohata]

Hi and welcome to the forum

Unfortunately pictures are rarely much use to us and we require actual workbooks (see guidance in rules area). Upload a workbook and no doubt more answers will be forthcoming.

ok, the file is attached. Originally, the hours and salary columns went on but it made the file weight 17mb...

Anyway, I dont want the formula to apply until i type in the variables .

[Richard Buttrey]

Hi,

In F2 copied down use

Please Login or Register  to view this content.

similarly in G2, preface it with an =IF($A2="",""

[Barohata]

Hi,

In F2 copied down use

Please Login or Register  to view this content.

similarly in G2, preface it with an =IF($A2="",""

Works, thank you very much!