See attached:
The SUMPRODUCT formula is
=SUMPRODUCT(($D$1>=$F$3:$F$9)*($D$1-$F$3:$F$9),$G$3:$G$9)
Table in F3:G9 which uses the increments (differences) in % (negative in your case!)
See attached:
The SUMPRODUCT formula is
=SUMPRODUCT(($D$1>=$F$3:$F$9)*($D$1-$F$3:$F$9),$G$3:$G$9)
Table in F3:G9 which uses the increments (differences) in % (negative in your case!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks