+ Reply to Thread
Results 1 to 5 of 5

checking cell contents and displaying a message

  1. #1
    Registered User
    Join Date
    05-24-2007
    Posts
    3

    checking cell contents and displaying a message

    I want to be able to create a worksheet where a cell checks that a preceding cell has a formula in it and then displays an appropriate message (in another cell) according to whether or not it is correct. I'm not sure whether it is a macro or an if statement.
    E.g. cells A1 & B1 have values in them, cell C1 is where the user types in the formula and cell D1 checks the contents of C1 and displays a relevant message, eg. correct or incorrect.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    What formula should be type in C1, addition, subtraction, multiplication, division, text manipulation?
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    05-24-2007
    Posts
    3
    Any really. The idea is to check that the formula is correct and return a message. So, in cell C1 it could be =A1+B1 and cell D1 would check and return a correct or incorrect message.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    I know Excel is good, but not that good, here's a list of some of the functions that could possibly go in C1 to give an answer?????????

    http://www.techonthenet.com/excel/formulas/

  5. #5
    Registered User
    Join Date
    05-24-2007
    Posts
    3
    Thank you, I will give them a go.

+ 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