Forum Discussion

spalmer's avatar
spalmer
Iron Contributor
Apr 02, 2019

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...
Formulas and Functions
spalmer's avatar
spalmer
Iron Contributor
Apr 02, 2019

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 

Twifoo's avatar
Twifoo
Silver Contributor
Apr 02, 2019
The formula you need in J3, copied down to J5, is:
=ISNUMBER(SEARCH("XXX",I3))*10+E3+H3
  • spalmer's avatar
    spalmer
    Iron Contributor
    Apr 03, 2019

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

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Apr 03, 2019
      You’re very much welcome!
      • spalmer's avatar
        spalmer
        Iron Contributor
        Apr 03, 2019

        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 

Resources