LinkBack URL
About LinkBacks
Here's one approach:
Does that help?
=SUMPRODUCT((A1>IF(B1,B1*{0;1;1}+{0;0;20},{0;20;40}))*(A1-IF(B1,B1*{0;1;1}+ {0;0;20},{0;20;40}))*{12;-2;-2.5})
Here's one approach:
Does that help?=SUMPRODUCT((A1>IF(B1,B1*{0;1;1}+{0;0;20},{0;20;40}))*(A1-IF(B1,B1*{0;1;1}+ {0;0;20},{0;20;40}))*{12;-2;-2.5})
Thanks! Both of these seemed to do what I want. Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks