Proper syntax for IF statement within macro

Another user generously shared this with me which sums up values in multiple columns and puts the summation in the first empty cell found. The number of values (rows) will vary each time. It works great but I now have another problem that I am hoping that can be added to this routine for simplicity but if another routine can do it, that is great too. Because the rows vary I thought it might make sense to just evaluate the sums at the same time but not certain! The description of my problem is below the routine.

Please Login or Register  to view this content.

Can I do an evaluation of the results and have it insert text in the next empty column cell (in the same row) based on the results? So if the results are in A4, B4 and C4, the text would appear in D4

For example, if the results show
8 5 0
it would return
8 5 0 NIGHT

I think the conditions I need look like this:

if column B value is not null insert NIGHT
if column B value and C value are 0 and A is not null insert DAY
if column A value and B value are 0 and C is not null insert ONLINE

I would appreciate any help someone can offer!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save