Change text of cell based on two other cells with equal values

Well, I guess I spoke too soon.

I almost works perfectly.

Cells B2 and C2 are populated by a formula. What's happening is that when there is no result (blank cell) in B2 or C2, A1 still shows "hourly".

Can we fix this?


Thanks!