Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Scenario summary or the IF scenario

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am learning about the scenario summaries can anyone explain these in a more simpified manner.
    I have done a few but none of them come out the way they are suppose to even though I go through all the steps.
    The main thing that always seems to be lacking is the summary part that you can type in t appear at the bottom of the scenario sheet, they are never there. What am I doing wrong.
    Please help as soon as possible, Im suppose to sit an exam in two weeks and I still havent worked this out.
    My second problem is the conditional cells, how do you get it to do three diffrent returns to give results poor if under 12000 ok if between 12000 and 15000 and good if over 15000.
    Thanks in advance
    Annie.x

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Annie,

    I can help with your second question. Are you trying to change the cell colors by those conditions or trying to insert "poor" etc in the cells?

    To change the cell colors, click on a cell, go to Format/Conditional Formatting/Cell Value is less than or equal to 12000, click format/patterns set your color OK, click add, then add your second and third conditions

    The first past needs a little more explanation.

    [ This Message was edited by: Brian from Maui on 2002-05-07 16:54 ]

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-07 15:50, Brian from Maui wrote:
    Annie,

    I can help with your second question. Are you trying to change the cell colors by those conditions or trying to insert "poor" etc in the cells?

    The first past needs a little more explanation.
    Hi Annie and Brian:
    Addresing the second part, since Brian has already started on that one, we don't need conditional formatting on that one , the following nested formula will do ...

    =IF(A1<=12000,"Poor",IF(A1<=15000,"OK","Good"))

    Regards!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hiya Brian and Yogi,

    Brian no I wasn't wanting the colour changed just the words into the cells but thank you for your reply.

    Yogi, Thats the formula I had for the cells but the excel 2000 office assistant keeps telling me that there are too many colons and brackets so it won't let the formula stay in place.Any ideas why?

    I gather neither of you knew about the scenario summaries.

    Thanks in advance,
    Annie.x

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 05:51, AnnieJhnstn wrote:
    Hiya Brian and Yogi,

    Brian no I wasn't wanting the colour changed just the words into the cells but thank you for your reply.

    Yogi, Thats the formula I had for the cells but the excel 2000 office assistant keeps telling me that there are too many colons and brackets so it won't let the formula stay in place.Any ideas why?

    I gather neither of you knew about the scenario summaries.

    Thanks in advance,
    Annie.x
    Hi Annie:
    Can you please post the formula you are using and a little bit more detail on the error that's being reported by Excel.

    Oh! and on the Scenarios issue, I thought I would let some one with more hands-on experience address it for you. If you don't hear any thing on that, either repost your original question, or post a new question on scenarios only.

    Regards!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •