Forum Discussion
Need help with formula
Hello. I am sure this is a simple problem. Formula to multiply part of the cell value, based on range, by a different %. Please see a simple example below. Cell value: $100,000 Column A ...
With such helper range
formula could be
=SUMPRODUCT((IF($A$2>$E$2:$E$5,$E$2:$E$5,$A$2)-$D$2:$D$5+1)*($A$2>$D$2:$D$5)*$F$2:$F$5)Jaymes1995 , you are welcome
