Quote:
Originally Posted by Yonkers
I have edited the spreadsheet so that if you have ZPP checked then Extended Leather (NDXY) will only cost $1100. If you don't have ZPP checked then it costs $2000.
To do this just change cell F3 of the spreadsheet to read
=IF(AND(A3="x",A24="x"),1100,IF(A3="x",E3,0))
Hope that helps.
|
Nice. I was going to include all of this logic but there are more "if thens" than this one. Either way post it up with all of the other corrections as well. We'll all appreciate it. Just zip and attach. Cheers.