+ Reply to Thread
Results 1 to 7 of 7

Help about the formula of Price that equal to Lenght

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Help about the formula of Price that equal to Lenght

    Hi I am new to this forum, great work by Excel Forum Team.

    I have some problem in my excel work, I dont now about the formula how i used for example

    Column 1 Column 2 Column 3

    Alumunum Bar is 100 cm = $222
    and 20 cm = ???

    I need help for above formula please help I am waiting for you reply.
    Last edited by adnanakhtar46; 05-07-2013 at 06:11 AM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Equal Formula (Help)

    A1=100. B1=222 A2=20.

    In B2 put this.

    =A2*B1/A1
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Equal Formula (Help)

    HI Adnan,

    welcome to the forum.
    Please change your thread title to reflect the query you are asking, see forum rules:-

    http://www.excelforum.com/forum-rule...rum-rules.html

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  4. #4
    Registered User
    Join Date
    05-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Equal Formula (Help)

    Its working. Thank you soo much for your quick reply. Gold bless you.

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Equal Formula (Help)

    Quote Originally Posted by adnanakhtar46 View Post
    Its working. Thank you soo much for your quick reply. Gold bless you.
    Gold bless you, too.

    Now pls take a moment and do what dilipandey requestes in previous post.

  6. #6
    Registered User
    Join Date
    05-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Help about the formula of Price that equal to Lenght

    Yes I already do, My English problem

  7. #7
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Help about the formula of Price that equal to Lenght

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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