Results 1 to 7 of 7

Thread: Need help with what if analysis

  1. #1

    Need help with what if analysis



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I couldn't make what if analysis data table

    first row is ok but others returning same number

    variable is @ row 13
    CGS %

    that should change for each month

    If anyone could check whats wrong with it

    I really got frustrated
    Attached Files Attached Files

  2. #2
    I can't see the same numbers anywhere.

  3. #3
    The analysis starts @ row 30
    I want it to change c17-j17 for each month
    The first month/row in the data table is fine
    But i couldnt make it for the rest
    Thanks for the reply

  4. #4
    I don't know if you think that response answers my question, but it certainly makes nothing clearer for me.

  5. #5
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Not sure I understand your question, but maybe
    C13 should be =C30
    and then copied across though D13:J13
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

  6. #6
    i'm sorry if i wasn't clear

    my problem is when i make a what-if-analysis data tables

    the results for the changed variable is the same

    but not for the first row

    i've done the same with other cell and it worked fine

    but when i used it on C13 it didn't work the way it should

    i hope these pictures would clear things up and i will upload a new sheet used in the pictures

    this shows the problem:

    Click image for larger version. 

Name:	1.jpg 
Views:	70 
Size:	102.0 KB 
ID:	3100

    this what it should be like:

    Click image for larger version. 

Name:	3.jpg 
Views:	30 
Size:	103.6 KB 
ID:	3101

    i made what-if-analysis on another cell and it worked fine:

    Click image for larger version. 

Name:	2.jpg 
Views:	31 
Size:	103.5 KB 
ID:	3102
    Attached Files Attached Files

  7. #7
    Quote Originally Posted by Roger Govier View Post
    Not sure I understand your question, but maybe
    C13 should be =C30
    and then copied across though D13:J13
    that worked and thanks for that

    but i may change the cells and can differ from C13

Posting Permissions

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