Hello,
I have this formula that is working but I find it quite long so I was wondering if it can be shorten
=MIN(1,(D$263+Transpose!$Q2-IF(Transpose!$O2=0,D$264,Transpose!$O2))%)*Transpose!$P2+
MIN(1,(D$263+Transpose!$T2-IF(Transpose!$R2=0,D$264,Transpose!$R2))%)*Transpose!$S2+
MIN(1,(D$263+Transpose!$W2-IF(Transpose!$U2=0,D$264,Transpose!$U2))%)*Transpose!$V2
Hi
Are you able to share the workbook (or at least the relevant part of it) with us so that we can see the request in context?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Here it is :
The formula above is part of the formula in cell D267
Last edited by KlawdStrife; 04-14-2014 at 11:56 AM.
Hi,
Please upload the workbook to the forum. Many of us prefer to avoid other file depositories.
Hello, here is the file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks