If function for workday & weekend

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,2)<6,C2,C2/3)

--
Regards,
Tom Ogilvy


"insplkm" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> insplkm
> ------------------------------------------------------------------------
> insplkm's Profile:
http://www.excelforum.com/member.php...o&userid=28771
> View this thread: http://www.excelforum.com/showthread...hreadid=484600
>

On Sat, 12 Nov 2005 18:43:35 -0600, insplkm
<[email protected]> 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