How to add value (£) to worded cells?

My objective is to find the total value of a customisable product.


1. The top right table with the attributes, each need to have a monetary value, ie tall = £10, wide =£20 etc

2. In the third table, with the combinations, it needs to be printed out in another table so the string looks like this:

Tall-Black-No-No-No-No-No

With each attribute separated with a hypon.

3. Finally, I'll need to find the total value of that string.
I've tried racking my brain to figure out how to do this, but I am just not making any progress. I hope someone will be able to help!

many thanks in advance!

________________________________________________________________________________ __________________________________________________

Materials:

Formulas provided by Wayne

https://www.dropbox.com/sh/fzpc69aya48qftj/AABYxu0BpAhupXBFCz8P_qHfa

iMac (27-inch, Late 2012)

Posted on Sep 16, 2014 6:47 AM

Reply

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to add value (£) to worded cells?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.