• 460K Members
• 9,344 Online
• 558K Conversations

Contributor

# Formula Help

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

12 Replies

# Re: Formula Help

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?

# Re: Formula Help

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

# Re: Formula Help

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

# Re: Formula Help

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

# Re: Formula Help

You’re very much welcome!

# Re: Formula Help

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?

# Re: Formula Help

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

# Re: Formula Help

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

# Re: Formula Help

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

# Re: Formula Help

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

# Re: Formula Help

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.

# Re: Formula Help

ok thank you sir@Twifoo

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies