 Forums »  List all forums » »  Forum: Tips & Tricks, Questions & Answers » » »  Thread: The Shop Tool » » » »  Post: Re: The Shop Tool Print at Jun 5, 2020 12:34:26 AM

Posted by amoyer at Feb 27, 2008 6:26:35 PM
Re: The Shop Tool
That formula is only for the furnisher. The one for the tailor requires that you change this...

+(IF(AK102>AM102,(VLOOKUP(VLOOKUP(AK15,\$Q\$35:\$X\$70,8,0),\$N\$35:\$V\$70,8,FALSE)),VLOOKUP(VLOOKUP(AK15,\$Q\$35:\$X\$70,8,0),\$M\$35:\$V\$70,8,FALSE))*(AK102+AM102))+N("Cloth 1 Calculations")
+(IF(AL102>AN102,(VLOOKUP(VLOOKUP(AL15,\$Q\$35:\$X\$70,8,0),\$N\$35:\$V\$70,8,FALSE)),(VLOOKUP(VLOOKUP(AL15,\$Q\$35:\$X\$70,8,0),\$M\$35:\$V\$70,8,FALSE)))*(AL102+AN102))+N("Cloth 2 Calculations")

to this...

+(IF(AK102>AM102,(VLOOKUP(VLOOKUP(AK15,\$Q\$35:\$X\$70,8,0),\$N\$35:\$V\$70,8,FALSE)),VLOOKUP(VLOOKUP(AK15,\$Q\$35:\$X\$70,8,0),\$M\$35:\$V\$70,9,FALSE))*(AK102+AM102))+N("Cloth 1 Calculations")
+(IF(AL102>AN102,(VLOOKUP(VLOOKUP(AL15,\$Q\$35:\$X\$70,8,0),\$N\$35:\$V\$70,8,FALSE)),(VLOOKUP(VLOOKUP(AL15,\$Q\$35:\$X\$70,8,0),\$M\$35:\$V\$70,9,FALSE)))*(AL102+AN102))+N("Cloth 2 Calculations")

Seems to work for all items in the tailor regardless of whether they have fine, regular or both cloth types.
----------------------------------------
Cedarwings
Captain of the Crew Schmew of the Flag Schmag
Cobalt Ocean
 Oceanus wrote: "I hear Atlantis is all fun and giggles"