How many nested statements is this?

  • Thread starter Thread starter johnhildreth
  • Start date Start date
J

johnhildreth

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
 
If you are doing it in VBA, is there any reason to put the formula in,
why not just put the value?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Macro Across More Than One Sheet 3
New to SUMPRODUCT .. is there a better way? 1
After Applying NSA Security Template, No Shared Cipher on all HTTPS Pages 2
base64 encode/decode issue 2
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Windows 7 Problem with Facebook 9
Security -- Firewall and the shortcomings of Internet Explorer 7compared to Mozilla Firefox 6
Copy item from Outlook to folder via Excel 12

Back
Top