+ Reply to Thread
Results 1 to 6 of 6

Multiply formula not Working

  1. #1
    Registered User
    Join Date
    07-30-2017
    Location
    Israel
    MS-Off Ver
    10
    Posts
    6

    Multiply formula not Working

    Hey guys thanks inadvance to all,
    Hope il can make this as clear as possible,
    I am trying to make a simple calculator for personal uses, but I am running with some issues

    I am trying to reference a cell that already has a "divide Formula" in it , for my next calculation.
    Im basically using this formula ;
    Please Login or Register  to view this content.
    to get the required value on cell B18. the issue is that the
    cells im taking the values from are updating but cell number B18 is not. Its only calculating the math
    but not updating when I enter different values.
    **It seems to happen only with the multiply formula but other work fine. you can check the sheet here


    Thanks in advance to all

    https://docs.google.com/spreadsheets...it?usp=sharing

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Multiply formula not Working

    B18 contains =B13 * 8

    B13 contains =B12/4, so B18 =B12/4 * B8, right?

    B12 contains =B7/B8, so B18 = B7/B8 / 4 * B8, which is just B7/4 as long as B8 <> 0

    So the value of B18 doesn't depend on B8 at all, unless it's 0, in which case it returns an error.
    Last edited by shg; 07-30-2017 at 03:57 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Multiply formula not Working

    If you change goal value then "B18" value changed. But if avg oranges value change then no change because in "B18" you mentioned divided by 4.
    Presently "B7" is 2000 "B8" is 50
    "B12" is =B7/B8 mean answer 40
    "B13" is =B12/4 mean 10
    "B18" is =B13*B8 mean 10*50 = 500

    If you change "B8" is 25 then
    "B12" is 80 (2000/25)
    "B13" is 20 (80/4)
    "B18" is 500 (B13*B8) (20*25)
    formula calculate perfectly in "B18" as per your related all formula's.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    07-30-2017
    Location
    Israel
    MS-Off Ver
    10
    Posts
    6

    Re: Multiply formula not Working

    Hey man Thanks for the reply, Yeah My bad, Totally got messed up with all this math appreciate the quick response of both of view have a great day all

  5. #5
    Registered User
    Join Date
    07-30-2017
    Location
    Israel
    MS-Off Ver
    10
    Posts
    6

    Re: Multiply formula not Working

    Hey man Thanks for the reply, Yeah My bad, Totally got messed up with all this math appreciate the quick response of both of view have a great day all And agian thanks to both reputation up for both

  6. #6
    Registered User
    Join Date
    07-30-2017
    Location
    Israel
    MS-Off Ver
    10
    Posts
    6

    Re: Multiply formula not Working

    Im trying to give you repution and it doesnt let me man sorry il try later

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. simple multiply formula not working
    By baltais in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-15-2017, 03:41 PM
  2. Replies: 4
    Last Post: 01-10-2014, 09:32 AM
  3. If criteria match, multiply then sum across multiply worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 02:20 PM
  4. [SOLVED] Multiply Formula Help
    By rif in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 07-24-2012, 03:36 AM
  5. [SOLVED] Multiply formula
    By thair in forum Excel General
    Replies: 4
    Last Post: 05-08-2012, 07:02 AM
  6. Multiply IF formula?
    By lintcoop in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2008, 09:08 AM
  7. How can I set up a formula to multiply $ x hrs? i.e. 8:30 (8hr 30.
    By Tradeshow help in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2005, 08:06 PM

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