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
Twifoo's avatar
Twifoo
Silver Contributor
Apr 03, 2019
You modified the layout of your data, such that the formula in K3, copied down to K5, must also be modified as:
=E3+J3
spalmer's avatar
spalmer
Iron Contributor
Apr 03, 2019

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 

  • spalmer's avatar
    spalmer
    Iron Contributor
    May 02, 2019

    ok thank you sirTwifoo 

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 02, 2019
    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.
  • spalmer's avatar
    spalmer
    Iron Contributor
    May 02, 2019

     

    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 SergeiBaklan 

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 03, 2019
    Use SUM like this:
    =SUM(ISNUMBER(SEARCH(“XXX”,I3))*10,E3,H3)

Resources