Hi Mark,

Apart from anything else, you formula doesn't cater for G109=70% or G109=100%. Plus all the nested IFs seem to be pointing to the
same sum: SUM(G90-G96). Note also the odd positioning of the closing brackets for the AVERAGE('Base Data'!$I$31:$I$35 functions -
they're all at the end of the formula. It seems you're trying to nest the 70% test results inside the 'AVERAGE' function.

Perhaps you could explain what you're trying to do. Maybe something along the lines of:
=IF(G109<70%),1,IF(G109<100%,2,3))*(G90-G96)*AVERAGE('Base Data'!$G$31:$G$35)
where the 1,2,3 represent constants for the G109 % values?
--
Cheers
macropod
[Microsoft MVP - Word]


"Mark D" wrote in message ...
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