How would I use a value from another cell as part of a variable in this
example?
=NETWORKDAYS('Recap Report'!$A$7,'Recap Report'!Aamp;(VALUE($K$3)))
Regards
ParTeeGolfer--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: www.excelforum.com/member.php...oamp;userid=31951
View this thread: www.excelforum.com/showthread...hreadid=535661=NETWORKDAYS('Recap Report'!$A$7,INDIRECT(quot;'Recap Report'!Aquot;amp;$K$3))--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;parteegolferquot; gt;
wrote in message
news
gt;
gt; How would I use a value from another cell as part of a variable in this
gt; example?
gt;
gt; =NETWORKDAYS('Recap Report'!$A$7,'Recap Report'!Aamp;(VALUE($K$3)))
gt;
gt; Regards
gt; ParTeeGolfer
gt;
gt;
gt; --
gt; parteegolfer
gt; ------------------------------------------------------------------------
gt; parteegolfer's Profile:
www.excelforum.com/member.php...oamp;userid=31951
gt; View this thread: www.excelforum.com/showthread...hreadid=535661
gt;
Thanks Bob!--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: www.excelforum.com/member.php...oamp;userid=31951
View this thread: www.excelforum.com/showthread...hreadid=535661
- Jul 16 Mon 2007 20:38
Correct Format for formula
close
全站熱搜
留言列表
發表留言