Try
=SUMPRODUCT(--(B2>={0,30000,250000,400000,1000000000}),B2-{0,30000,250000,400000,1000000000},{0.35,0,5,-0.1,-0.1})
Try
=SUMPRODUCT(--(B2>={0,30000,250000,400000,1000000000}),B2-{0,30000,250000,400000,1000000000},{0.35,0,5,-0.1,-0.1})
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks