+ Reply to Thread
Results 1 to 14 of 14

maths problems

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    maryport
    MS-Off Ver
    Excel 2013
    Posts
    54

    Angry maths problems for math test

    Hi, i would like to create a spreadsheet for my son to use, to test his maths skills. In column A would be the problems, column B his input (the answer) and colum C a simple IF a=b statement. The problem is, ive tried a million different ways, and i cant do column A properly.

    I would like the test questions in column A to be randomly generated numbers. so i tried =randbetween(1,10)&"+"&randbetween(1,20) but no luck, as excel doesnt see it as a math problem so column C always shows incorrect. I tried =(randbetween(1,10)+(randbetween(1,20)) but still no luck, it just does the equation and shows the answer in the cell. But i would like it to show 1+4, 10+7 etc....


    Can ANYONE help??
    Last edited by brucey2343; 09-05-2013 at 10:11 AM.

  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: maths problems

    Hi,

    Have you tried, for example:

    =RANDBETWEEN(1,20)&"+"&RANDBETWEEN(1,20)

    Regards
    Click * below if this answer helped

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

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: maths problems

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    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
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    08-07-2013
    Location
    maryport
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: maths problems

    Hi, i would like to create a spreadsheet for my son to use, to test his maths skills. In column A would be the problems, column B his input (the answer) and colum C a simple IF a=b statement. The problem is, ive tried a million different ways, and i cant do column A properly.

    I would like the test questions in column A to be randomly generated numbers. so i tried =randbetween(1,10)&"+"&randbetween(1,20) but no luck, as excel doesnt see it as a math problem so column C always shows incorrect. I tried =(randbetween(1,10)+(randbetween(1,20)) but still no luck, it just does the equation and shows the answer in the cell. But i would like it to show 1+4, 10+7 etc....


    Can ANYONE help??

  5. #5
    Registered User
    Join Date
    08-07-2013
    Location
    maryport
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: maths problems

    Hi, i would like to create a spreadsheet for my son to use, to test his maths skills. In column A would be the problems, column B his input (the answer) and colum C a simple IF a=b statement. The problem is, ive tried a million different ways, and i cant do column A properly.

    I would like the test questions in column A to be randomly generated numbers. so i tried =randbetween(1,10)&"+"&randbetween(1,20) but no luck, as excel doesnt see it as a math problem so column C always shows incorrect. I tried =(randbetween(1,10)+(randbetween(1,20)) but still no luck, it just does the equation and shows the answer in the cell. But i would like it to show 1+4, 10+7 etc....


    Can ANYONE help??

  6. #6
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: maths problems

    I would like suggest you to choose three celll..
    Cell 1 & 3 for Number and middle cell for +.. becouse, Operator Overloading is not a the feature Excel Programming language, and
    need to keep away from childrens..

    Chekc this one..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  7. #7
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: maths problems

    it would never work. .randbeween(1,10)&"+"&randbeween(1,10) which can be evaluated would change as soon as a value is entered in col b
    ie 1+9 which we know =10 but if you put 10 in col b the randbetween() would recalculate and could become say 3+6 so 10 would now be wrong
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  8. #8
    Registered User
    Join Date
    08-07-2013
    Location
    maryport
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: maths problems

    brilliant, thank you very much

  9. #9
    Registered User
    Join Date
    08-07-2013
    Location
    maryport
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: maths problems

    ok martin, do you have an alternative? i never thought about that...

  10. #10
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: maths problems

    you would need someone to write code so you could have non volatile rand()

  11. #11
    Forum Contributor
    Join Date
    07-02-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    197

    Re: maths problems

    Quote Originally Posted by martindwilson View Post
    it would never work. .randbeween(1,10)&"+"&randbeween(1,10) which can be evaluated would change as soon as a value is entered in col b
    ie 1+9 which we know =10 but if you put 10 in col b the randbetween() would recalculate and could become say 3+6 so 10 would now be wrong
    And the solution is a macro that copy the random result to the cell as values

  12. #12
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: maths problems

    or generate them somewhere copy paste special values to a sheet to work from

  13. #13
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: maths problems

    here is a workbook using evaluate()
    Attached Files Attached Files
    Last edited by martindwilson; 09-05-2013 at 11:46 AM.

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: maths problems

    Im sorry, but i fail to see how changing the title from "maths problem" to "maths problems for math test" is any more descriptive of what your problem is???

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

+ 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. Excel Maths
    By skate1991 in forum Excel General
    Replies: 11
    Last Post: 10-09-2012, 09:47 AM
  2. More of a Maths question!!
    By Icehockey44 in forum Excel General
    Replies: 1
    Last Post: 11-28-2011, 06:28 AM
  3. help: Maths and formula help
    By legion in forum Excel General
    Replies: 5
    Last Post: 03-29-2009, 07:43 PM
  4. Maths Fonts
    By Sue in forum Excel General
    Replies: 2
    Last Post: 10-25-2005, 07:05 AM
  5. VBA Basic Maths Problems
    By DaveUK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2005, 09:52 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