=(G90-G96)*AVERAGE(OFFSET('Base Data'!G31:G35,,
LOOKUP(G109,{0,0.7,1},{2,1,0})))

--
Jacob


"Mark D" wrote:

Hi Jacob

I have entered this formula in but am getting the error dialogue box come
up. It's highlighting a problem with G96???

"Jacob Skaria" wrote:

Try the below

=(G90-G96)*AVERAGE(OFFSET(G31:G35,,LOOKUP(G10,{0,0.7,1}, {2,1,0})))

--
Jacob


"Mark D" wrote:

Good morning everyone.

I have the following calculation that is causing me a problem

=IF(G109<70%,SUM(G90-G96)*AVERAGE('Base
Data'!$I$31:$I$35,IF(G10970.01%<99.99%,SUM(G90-G96)*AVERAGE('Base
Data'!$H$31:$H$35,IF(G109100%,SUM(G90-G96)*AVERAGE('Base
Data'!$G$31:$G$35))))))

The 1st part of the formula (<70% ) is working and returning a value.
However if the % is greater than 70% I am getting the result FALSE

I'm sure it's a simple fix but cannot put my finger on it

Any help greatly appreciated,

Thanks