Excel & Business Math 17: Solve Fractional Business Math Problems using Excel



Download Start Excel File: …

source

11 Replies to “Excel & Business Math 17: Solve Fractional Business Math Problems using Excel”

  1. I'm sorry for commenting on this video but i need your help.

    I am looking to find a price for 1st & 2nd class stamp and format(letter,large letter,small parcel etc) by parcel weight. royal mail postage for eBay business. for example if i insert product weight than format, 1st & 2nd class price should show automatic. please tell me what formulas i need to find these prices and format. Thank you.

    Weight (grams) Format 1st class 2nd class
    Insert Auto Auto Auto

    Table
    Format Weight Max Grams  1st Class   2nd Class 
    Letter 100  £       0.65   £          0.56 
    Larger letter 101  £       0.98   £          0.76 
    Larger letter 250  £       1.30   £          1.22 
    Larger letter 500  £       1.74   £          1.58 
    Larger letter 750  £       2.52   £          1.14 
    Small parcel 1000  £       3.40   £          2.90 
    Small parcel 2000  £       5.50   £          2.90 
    Medium Parcel 1000  £       5.70   £          5.00 
    Medium Parcel 2000  £       8.95   £          5.00 
    Medium Parcel 5000  £    15.85   £        13.75 
    Medium Parcel 10000  £    21.90   £        20.25 
    Medium Parcel 20000  £    33.40   £        28.55

  2. Sir, I'm one of your subscribers. Would you please make a video on how to create ordinal number formatting with format cell dialog box in excel? For instance, if i write 1, 2, 3, 4 respectively, as soon as I hit enter, it will convert to ordinal number format like 1st, 2nd, 3rd, 4th etc.. (Note: Don't use any formula or vba)

Comments are closed.