+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Formula required to reflect error message

  1. #1
    Registered User
    Join Date
    10-26-2005
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    2

    Formula required to reflect error message

    Hi
    I require a formula for C15. If any cell in the range D14 to NK14 has the word Error, then show "Error" in C15, else leave blank. Cells D14 to NK14 represent the quotient of D13 to NK13 and a constant.
    eg. D14=D13/constant. There are some instances where some values in the row 14 will reflect an "error" msg. I need C15 to tell me "Error" if there is any instance of an error in any Row14

    (I am having difficulty uploading a sample)

    your help is appreciated
    Roxio
    Last edited by Roxio; 04-01-2009 at 09:24 PM.

  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: Error message

    Please read the forum rules about thread titles, and then amend yours accordingly.
    Entia non sunt multiplicanda sine necessitate

+ 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