Hi,
I use the following formula all the time: =IF(H2="Saturday", "Saturday", IF(H2="Sunday", "Sunday", IF(K2>0.79, "Evening", "Daytime"))), where the H column has the day of the week and the K column the time.
Each time I have a new speadsheet I type this in from scratch and copy it down for as many rows as I have (generally a few thosand), not a big deal I'll grant you.
I was wondering would it be 'better' to make a custom function that performs this task and if so how should one go about this. I understand the concepts around creating a custom function but it's all very new.
Any help would be appreicated.
Andy.
Bookmarks