+ Reply to Thread
Results 1 to 7 of 7

Formula to mark cell to input number into it

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    columbia, kentucky
    MS-Off Ver
    Excel 2003
    Posts
    3

    Formula to mark cell to input number into it

    on my spreadsheet - can I mark cell c3 with an "x" which would put a number in cell e3 ????
    Last edited by arlu1201; 07-17-2013 at 02:28 PM. Reason: Edited thread title for user.

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: unable to create proper formula

    What number? you could use
    Please Login or Register  to view this content.
    Put this in E3
    Last edited by Hurricanefly; 07-17-2013 at 02:29 PM.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: unable to create proper formula

    Quote Originally Posted by Hurricanefly View Post
    What number? you could use
    Please Login or Register  to view this content.
    Put this in E3
    If a number is to be input, "1" is not a good example. Double quotes indicate a string....

  4. #4
    Registered User
    Join Date
    07-17-2013
    Location
    columbia, kentucky
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula to mark cell to input number into it

    thank you so much......it put the number in perfectly......however I lost the ability to total the column.....any suggestions.????

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Formula to mark cell to input number into it

    If you put the " " around the number generated by the X in C3, that number will be text and not included in the sum....is that what you mean? If yes, remove the " ".
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  6. #6
    Registered User
    Join Date
    07-17-2013
    Location
    columbia, kentucky
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula to mark cell to input number into it

    that worked perfectly....thank you so much.......

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Formula to mark cell to input number into it

    Thank you for giving feedback.

+ 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. Replies: 7
    Last Post: 12-16-2011, 02:41 PM
  2. different:General Question
    By mtaystl11 in forum Excel General
    Replies: 5
    Last Post: 06-24-2006, 10:55 AM
  3. [SOLVED] General Question
    By Me in forum Excel General
    Replies: 3
    Last Post: 01-12-2006, 09:00 AM

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