How many nested statements is this?

[johnhildreth@citynet.net]

I think there are 8...7 IF statements and then the AND/OR under them.
Any suggestions for rewriting this to fit under the limit. I can pull
the first IF into VBA code but the references get quite difficult and
lengthy...but it can be done.

=IF(OR(Update!RC3>R10C,Update!RC4<R10C[-1]),0,
IF(Update!RC4=R10C[-1],1,
IF(AND(Update!RC3>=R10C[-1],Update!RC4<R10C),Update!RC7,
IF(AND(Update!RC3<=R10C[-1], Update!RC4=R10C),R10C-Update!RC3,
IF(AND(Update!RC3<=R10C[-1],Update!RC4>=R10C),R10C-R10C[-1],
IF(AND(Update!RC3<R10C[-1],Update!RC4<=R10C),Update!RC4-R10C[-1]+1,
IF(AND(Update!RC3>=R10C[-1],Update!RC4>R10C),R10C-Update!RC3,9999)))))))


Thanks,
John

[aidan.heritage@virgin.net]

If you are doing it in VBA, is there any reason to put the formula in,
why not just put the value?