Assign value to list

First and foremost. I'm totally new to "programming" in Excel. I'm trying to make a price calculator, that calculates the price when I use my printer. The sheet contains list, so I don't need to type in numbers but can choose between some options. I would like options within the list to have a value. My sheet contains theese information.
**Description, Amount, Single/duplex, Format, Printing price, Paper price, Total price.** **Description:** Could be "Printing an invitation for my brother"
**Amount:** Amount printet
**Single/Duplex:** A list containing "Single" and "Duplex"
**Format:** A list containing "A4", "SRA3" and "SRA3 HiGloss"
**Printing price:** The total price
This is how it's calculated:
**'Format' + ('Amount' x 'Single/duplex') = 'Printing price'**

I would like to assign theese values to the list options: **Single/Duplex**
Per page (singlex): 0,6
Per page (duplex): 1,2 **Format:**
A4. paper: 0,2
SRA3 High Gloss: 1,25
SRA3: 1 **Example** Description Amount Single/Duplex Format Printing price Invitations 30 Duplex SRA3 HiGloss 61,25 The calculation for this example looks like this:
**'Format' + ('Amount' x 'Single/duplex') = 'Printing price'**
**1,25+(30*2)** Does anyone know about this???
Kenneth, not exactly sure what question you are trying to get answered. You might get better results if you ask a specific question.

以上就是Assign value to list的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准