Formula Help

[spalmer]

In the photo above im trying to create a formula in J3-J5.  a quick description.  Black pants cost $50 and Tan pants cost $60.  but if the person needs XXX-Large pants there is an added $10 fee for anything above XXX-large or higher. So for STEVE i need the formula to calculate the Sum of E5+H5 but i also need it to calculate an extra $10 for steve and anyone else that needs XXX-Large pants but at the same time not adding an extra $10 fee for matt who got a Medium size pant.  hopefully this isn't to confusing and any help would be greatly appreciated.  Thank you

@Damien Rosario @Sergei Baklan @Twifoo 

[#2]

What are the possible sizes of Pants?
Aside from "XXX-Large", what are the other sizes that require extra $10 fee? Aside from "Medium" and "Large", are there other sizes of that do not require extra $10 fee? For example, are there "Small" and "XXXX-Large" sizes?

[#3]

Yes Sir, there are small, medium, large, x-large, xx-large, xxx-large and xxxx-large.   xxx-large and xxxx-large will require an extra $10 fee. @Twifoo 

[#4]

The formula you need in J3, copied down to J5, is:
=ISNUMBER(SEARCH("XXX",I3))*10+E3+H3

[#5]

Thank you Sir. You are a genius haha.   I really appreciate it!  @Twifoo 

[#6]

You’re very much welcome!

[#7]

Hi Sir, so as you can see when I put in that formula its giving me a #value! error cause nothing is inputted in E3.  matt and steve don't need jerseys.  is there anyway to fix the formula to account for that?

@Twifoo 

[#8]

You modified the layout of your data, such that the formula in K3, copied down to K5, must also be modified as:
=E3+J3

[#9]

ok so I went back to the original photo I posted and inputted that formula but is giving me the same error.  what am I doing wrong Sir?   the formula works as long as someone gets a jersey as well.  again thank you for your time I really appreciate it.  @Twifoo 

[#10]

Use SUM like this:
=SUM(ISNUMBER(SEARCH(“XXX”,I3))*10,E3,H3)

[#11]

I have another question for you geniuses.  As you can see i have a master chart here and im trying to link a whole column to another worksheet based on the selection of what "Engine" they select. So at the bottom of this worksheet i have 3 tabs labeled "Engine 12", "Engine 13" and "Engine 14".  This sheet you see is the master sheet.  So when Joe Williams selects Engine 12 as the engine he will be working on i want the whole column of his info to link to the Engine 12 worksheet automatically.  I hope this makes sense to you all and please let me know if you need any other info.  thank you so much @Twifoo @Damien Rosario @Sergei Baklan 

[#12]

Given that you are raising another issue, I suggest you start another conversation and attach your sample file therein. Such file must contain your sample data along with the manually entered results which you want to be returned by formulas.

[#13]

ok thank you sir@Twifoo