mvnForum Homepage


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"


Puzzle Pirates™ © 2001-2016 Grey Havens, LLC All Rights Reserved.   Terms · Privacy · Affiliates