LinkBack URL
About LinkBacks
I have an error in the following formula that can't spot. Does anyone else see it? The formula as is returns #NAME?
Please Login or Register to view this content.
I have an error in the following formula that can't spot. Does anyone else see it? The formula as is returns #NAME?
Please Login or Register to view this content.
Last edited by nicolelschramartin; 01-01-2013 at 01:54 AM.
In many places you are just refering to W, without any row? is that correct? (W could be a range name, only you would know that?)
=IF(AND(W33=7,Y33=8),"*** saw start",IF(AND(W33=8,W=8,M12="sander"),"Sander start",IF(AND(W33=8,W=8,M12="surfacer"),"Surfacer start",IF(AND(W33=8,W=8,M12="profile"),"Grinder start",IF(AND(W33=8,W=8,M12="straight"),"Grinder start","error")))))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks