VALUE Error?

[blondie1986]

Hi can someone help me with this error?

=IF((V29)="S",IF(AD29>74,248920.9401+0*(AD29),1.35067946860357E-06*(AD29)^6+0.00088832910287806*(AD29)^5-0.268487961773644*(AD29)^4+25.7465964922449*(AD29)^3-1090.04674073308*(AD29)^2+22165.9671040624*(AD29)),IF((V29)="M",IF((AD29)>91,145829.4248+0*(AD29),-7.04429004355633E-06*(AD29)^6+0.00258043474963188*(AD29)^5-0.363821373940482*(AD29)^4+24.8747574753943*(AD29)^3-858.869388975203*(AD29)^2+14956.5037428364*(AD29)))),IF((AD29)<17,-0.122486704068251*(AD29)^6+6.95867903201724*(AD29)^5-152.096434958279*(AD29)^4+1620.29930101335*(AD29)^3-9241.609983325*(AD29)^2+34120.2580383718*(AD29),91031.23725+0*(AD29))

The Error shows Value, but the fields (V29) and (AD29) are actually filled with data?
Please help or give me some advice. Thanks!

[blondie1986]

i added an example sheet

[NickyC]

Hi

I think you may have the parentheses in the wrong place - try this

Please Login or Register  to view this content.

[blondie1986]

hi, thanks but the parentheses ahve to be on that spot otherwise the if function does not work anymore...

[blondie1986]

actually it is he parentheses thanks so muych