If function for workday & weekend
On Sat, 12 Nov 2005 18:43:35 -0600, insplkm
wrote:
Hi, I need help to setup a function with the following concept:
in A1, If today()-1 is a workday, take value directly from C2, if its
weekend, take value from C2 divide by 3.
Thanks.
=if(weekday(today()-1,3)<=4,c2,c2/3)
--ron
|