# If statement error. Constant error message

I am getting an error with an If statement I am trying to extend and don't know why.

Original statement =IF(MAX(E113:E117)<ABS(MIN(E113:E117)),MIN(E113:E117),MAX(E113:E117))

New statement required =if('12811-1'!E35>0,=IF(MAX(E113:E117)<ABS(MIN(E113:E117)),MIN(E113:E117),MAX(E113:E117)),calcs!M97)

cell is e75 in the calcs tab. Note I am using the NA() command to stop data being drawn on the charts based on parameters seen, so you will see  a lot of #NA.

Regards

Paul
scaffold-designer-v5.xlsm
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
You can't calculate max or min on errors, that leads to error.
The new statement in E75
=IF('12811-1'!E35>0,IF(MAX(E113:E117)<ABS(MIN(E113:E117)),MIN(E113:E117),MAX(E113:E117)),M97)
And similar in E76 I guess the formula should point to M95 when '12811-1'!E35 = 0
=IF('12811-1'!E35>0,C126,M95)
Commented:
I think the errors I had was due to my version of Excel are not able to use the IFS function.
When I changed the IFS formulas to nested IF, there was no error, so I guess the error you have in the formula is caused by the = before the second IF.

Experts Exchange Solution brought to you by