OurHeroJack
New Member
- Joined
- Feb 25, 2025
- Messages
- 2
- Office Version
- 2024
- Platform
- Windows
I have a pricing Matrix that with numerous ALPHANUMERIC TAGS.
example BOL1, CO3, YWE6, etc...
Each of these tags are code for a percentage value.
In this case BOL1 = 30%, CO3 = 24%, and YWE6 = 21%
I want to create a spread spreadsheet for customer that only shows ALPHA CODES but when multiplied by another cell number it uses the percentage instead of the tag/code.
Hope thats clear as mud
Shows BOL1 but actually has a value of .70 fr calculation purposes.
example BOL1, CO3, YWE6, etc...
Each of these tags are code for a percentage value.
In this case BOL1 = 30%, CO3 = 24%, and YWE6 = 21%
I want to create a spread spreadsheet for customer that only shows ALPHA CODES but when multiplied by another cell number it uses the percentage instead of the tag/code.
Hope thats clear as mud
Shows BOL1 but actually has a value of .70 fr calculation purposes.