+ Reply to Thread
Results 1 to 7 of 7

help with writing math equations

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2010
    Posts
    9

    help with writing math equations

    I once saw an excell page that you were able to just write in the numbers that you wanted in an equation and it figured it all out for you. I am trying to build that and need some help please. The equations are not just simple addition and subtraction. They are square roots, exponents etc. One equation in particular is the inverse square law. For this one you are trying to find the intensity of something. If anyone is able to help or point me in the right direction please.

    Thank you. Dan

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help with writing math equations

    Hi and welcome to the forum!

    Can you give a few examples of the equations in which you're interested?

    First we can translate the given equation into an Excel formula (or formulas), then, once we have that, we can simply change the variables (held in cells) to obtain the desired results.

    Regards
    Click * below if this answer helped

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

  3. #3
    Registered User
    Join Date
    11-13-2013
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: help with writing math equations

    I have attached a photo of the equation. Not really sure how I would put it into text. Thank you for your help.

    Dan
    Attached Images Attached Images

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: help with writing math equations

    Hi,

    Does the attached help
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Registered User
    Join Date
    11-13-2013
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: help with writing math equations

    Wow Richard, that was extremely helpful thank you very much.

    Dan

  6. #6
    Registered User
    Join Date
    11-13-2013
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: help with writing math equations

    Richard,
    Perhaps you can help me with a few more. I was able to figure out from your example how you set up something for division, multiplication etc. But with the examples I just added, once you find the answer to N, how would you add it into the equation? Also do you know who to add natural log or LN into the equation? Thank you again for all your help.

    Dan
    Attached Images Attached Images

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: help with writing math equations

    Does the attached help further...
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    11-13-2013
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2010
    Posts
    9

    Thumbs up Re: help with writing math equations

    Thank you very much. That is Awsome.

+ 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. Sorting Equations
    By PerdixDaedalus in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-10-2013, 10:34 PM
  2. Conditional equations
    By EGR2317 in forum Excel General
    Replies: 4
    Last Post: 06-03-2010, 10:08 AM
  3. Two Part Equations
    By Gub in forum Excel General
    Replies: 4
    Last Post: 05-28-2010, 12:20 PM
  4. Replies: 3
    Last Post: 02-16-2006, 07:00 AM
  5. [SOLVED] Excel equations...
    By thanatologist in forum Excel General
    Replies: 2
    Last Post: 03-24-2005, 10:06 PM

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