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

=if(weekday(today()-1,2)<6,C2,C2/3)

--
Regards,
Tom Ogilvy


"insplkm" wrote in
message ...

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
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