What's in C53 and k53?

You may want to post the exact formulas--copied from the formulabar--into your
posts. Sometimes typos exist in the real formula, sometimes typos are just
caused by typing the message.

"BNT1 via OfficeKB.com" wrote:

Hi, thanks for the response

I still get #VALUE! error

formula reads in M53 = if(iserror(networkdays(C53,K53))-1,"",networkdays(C53,
K53))-1
If I enter in M53 = if(a53="","",networkdays(c53,k53)0-1 I still get #VALUE!
error

incidentally, cells a53 :D53 contain if statement =if (="","" etc

Hope I explained so you can understand

Any idea how to fix this #VALUE!

regards

Brian

Dave Peterson wrote:
Maybe you meant:

=if(a1="","",networkdays(k1,k3)-1)

Wonder why no responce, entered in wrong grouping !

[quoted text clipped - 19 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1


--
Message posted via http://www.officekb.com

--

Dave Peterson