hi,
i have a problem in excel 2003.
i have letters M, S, L, For M i have 2different mathematical formulars (Developed with excel),the same for S and L,
now i have to do the following in order that excel filters M, S, L:
=IF((V27)=“S“,IF((AD29)>74,104976+0*(AD29),0.0375*(AD29)^5 - 6.8963*(AD29)^4+413.52*(AD29)^3-8610.5*(AD29)^2+104191*(AD29)+85176),IF((V27)="M",IF(AD29>88,0*(AD29)+1280822,-0.0004*(AD29)^5+0.1529*(AD29)^4-20.707*(AD29)^3+1005.5*(AD29)^2+5899.2*(AD29)-25153),IF((AD29)>57,0*(AD29)+1352447,0.0002*(AD29)^5-0.0825*(AD29)^4+15.974*(AD29)^3-1540.3*(AD29)^2+74354*(AD29)-87564)))
but excel always shows me the NAME error.
Can someone please help since i am new with excel.
Also sorry for my english but it is not my mothertongue.
hello blondie i think the first if you letter s is not properly quoted by ""
=IF((V27)="S",IF((AD29)>74,104976+0*(AD29),0.0375*(AD29)^5 - 6.8963*(AD29)^4+413.52*(AD29)^3-8610.5*(AD29)^2+104191*(AD29)+85176),IF((V27)="M",IF(AD29>88,0*(AD29)+1280822,-0.0004*(AD29)^5+0.1529*(AD29)^4-20.707*(AD29)^3+1005.5*(AD29)^2+5899.2*(AD29)-25153),IF((AD29)>57,0*(AD29)+1352447,0.0002*(AD29)^5-0.0825*(AD29)^4+15.974*(AD29)^3-1540.3*(AD29)^2+74354*(AD29)-87564)))
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
thank you so much. this was the problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks