Help with IF stament (getting result FALSE in some cases)
Hi Mark,
try
=IF(G109<70%,SUM(G90-G96)*AVERAGE('Base
Data'!$I$31:$I$35,IF(AND(G10970.01%,G109<99.99%), SUM(G90-G96)*AVERAGE('Base
Data'!$H$31:$H$35,IF(G109100%,SUM(G90-G96)*AVERAGE('Base
Data'!$G$31:$G$35))))))
"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
|