Hi, I’m creating a calculator which will show an expectation each day someone is at work.
Currently this is what I have, so on a weekday it returns 5, weekends return 8.
However I would like it to return an empty cell if C3 is empty as this means they are not in.
=IF(WEEKDAY(A3,2)>5,8,5)
How can I update this to return a blank cell if C3 is empty?
Thanks.
Currently this is what I have, so on a weekday it returns 5, weekends return 8.
However I would like it to return an empty cell if C3 is empty as this means they are not in.
=IF(WEEKDAY(A3,2)>5,8,5)
How can I update this to return a blank cell if C3 is empty?
Thanks.