Results 1 to 4 of 4

Calculate Vendor price to Sale Price

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    LA
    MS-Off Ver
    Excel 2007
    Posts
    32

    Calculate Vendor price to Sale Price

    My issue is calculating vendor cost to sale price. I have a series of text boxes that pull data from my spread sheet which works fine. I have an update command button to change pricing and a calculate command button to update my sale price. What I get is something that looks the for my cost, price, and sale price 7212116.4 instead of the correct dollar amount. Below is the code I'm currently using and including the workbook as well

    Private Sub cmdCalculate_Click()
    
        Me.txtCost.Value = (Me.txtListPrice.Value - Me.txtListPrice.Value * Me.txtDiscount.Value)
        Me.txtPrice.Value = (Me.txtCost.Value * (1 + Me.txtMarkup.Value))
        Me.txtLaborPrice.Value = (Me.txtLaborRate.Value * Me.txtLaborHours.Value)
        Me.txtSalePrice.Value = (Me.txtLaborPrice.Value + Me.txtShipping.Value + Me.txtPrice.Value)
        
    End Sub
    .

    I would appreciate any help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2013 wants to calculate Sales Price , If cost price exits and wants change SP
    By Bitto in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 12:49 PM
  2. [SOLVED] Multiple IF's to calculate price based on cost and add handling charge and round price
    By RoyRose in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-13-2014, 01:18 PM
  3. calculate retail price based on mark up on cost price
    By pvl in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-27-2014, 03:49 AM
  4. Replies: 5
    Last Post: 02-06-2012, 06:21 AM
  5. How to calculate final sale price
    By ascottbag in forum Excel General
    Replies: 0
    Last Post: 01-29-2012, 10:48 PM
  6. Calc Final Sale Price Including % of Sale?
    By kierenschneider in forum Excel General
    Replies: 1
    Last Post: 10-26-2009, 01:09 PM
  7. [SOLVED] calculate/convert volume price to monthly average price
    By Bultgren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2006, 05:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1