4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

Excel Help

by dbwebdesignz
3 replies
  • OFF TOPIC
    • |
Hi guys,

I have some knowledge of excel but i am not sure if this is possible:

I have a table like this.

Coffee |____|
Tea |____|
Sugar |____|

Total |____|


I want to have a hidden value. So if i am with someone and they say Ok i want a tea + sugar it then uses their values to price it up in a total box.

So say Tea = $5 and sugar = $1 if i place 'yes' in the coffee and sugar box it then places $6 in the total.

Any help is apreciated
  • Profile picture of the author blackjack
    Hi

    Yes it is possible with IF statement and pricing hidden in the sheet.

    Column A Column B

    Coffee Yes/No
    Sugar Yes/No

    Total This would be if statement = IF( (Column B Row 1= "Yes" ) THEN coffe price

    It is hard to explain than to do it. If you want PM me your email and I'll send you an example in Excel.

    Thanks
    {{ DiscussionBoard.errors[7025889].message }}
    • Profile picture of the author roto009
      If possible, please make a video and upload to youtube and share the link with us. I also want to learn this.

      Originally Posted by blackjack View Post

      Hi

      Yes it is possible with IF statement and pricing hidden in the sheet.

      Column A Column B

      Coffee Yes/No
      Sugar Yes/No

      Total This would be if statement = IF( (Column B Row 1= "Yes" ) THEN coffe price

      It is hard to explain than to do it. If you want PM me your email and I'll send you an example in Excel.

      Thanks
      {{ DiscussionBoard.errors[7031577].message }}
  • Profile picture of the author seasoned
    You CAN simply highlight the range of elements, right click, and select hide. It CLAIMS unhide works the same way, but that is unlikely, and doesn't work in my version. You CAN grab the border and pull it open.

    Steve
    {{ DiscussionBoard.errors[7032778].message }}

Trending Topics