LinkBack URL
About LinkBacks
Why the need to do this with VBA?
A recular formula in that cell, copied down, shoud do the same thing...
=If(R3="Academic","n/a",IFERROR(IF(OR(K3=I3, AND(K3<I3,K3+L3=I3),OR(ISBLANK(K3:L3),L3=0), K3+L3>I3), 0, I3-K3-L3), ""))
Why the need to do this with VBA?
A recular formula in that cell, copied down, shoud do the same thing...
=If(R3="Academic","n/a",IFERROR(IF(OR(K3=I3, AND(K3<I3,K3+L3=I3),OR(ISBLANK(K3:L3),L3=0), K3+L3>I3), 0, I3-K3-L3), ""))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks