+ Reply to Thread
Results 1 to 4 of 4

Pricing Window Calculator Formula

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    2

    Pricing Window Calculator Formula

    Hi there

    Can someone please help with a formula to work out prices on windows.

    It is based on Width x Drop = $

    0-595mm x 0-920mm = $106 (example 400x500=$106)

    0-595mm x 921-1220mm = $111

    596-811mm x 0-920mm = $121 (example 700x800=$121)

    596-811mm x 921-1220mm = $126

    All i want on an excel sheet are 3 fields, WIDTH DROP PRICE


    I just cant seem to figure out how to imput the formulas.


    Please help

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Pricing Window Calculator Formula

    Hello,

    Assuming you have Width on A2, Drop on B2, you can paste this formula on C2
    Please Login or Register  to view this content.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,920

    Re: Pricing Window Calculator Formula

    Or use a table
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Pricing Window Calculator Formula

    Assuming Width on A2, and Drop on B2

    C2: =LOOKUP(A2,{0,596},CHOOSE({1,2},LOOKUP(B2,{0,921},{106,111}),(LOOKUP(B2,{0,921},{121,126}))))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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