Excel Help

by 3 replies
4
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
#off topic forum
  • 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
    • [1] reply
    • If possible, please make a video and upload to youtube and share the link with us. I also want to learn this.

  • 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
Join the discussion

Next Topics on Trending Feed