Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I need assist to do the following per the attached workbook

    1) I need to calculate the cumulative cash flow using the AND function as a logical alternative

    2) I have calculated the payback period, but need help to calculate the payback using an alternative method using a nested if function for cell C93:J93


    Your assistance will be most appreciated

    Regards

    Howard
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HowardC' post='774443' date='10-May-2009 01:03']I need assist to do the following per the attached workbook

    1) I need to calculate the cumulative cash flow using the AND function as a logical alternative

    2) I have calculated the payback period, but need help to calculate the payback using an alternative method using a nested if function for cell C93:J93


    Your assistance will be most appreciated

    Regards

    Howard[/quote]

    It is unclear on what you want to do
    would you stated what are the criterias?
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    [quote name='franciz' post='774457' date='09-May-2009 19:25']It is unclear on what you want to do
    would you stated what are the criterias?[/quote]

    With regard to my point 1 , the formula in C93:J93, must produce the same result as in C92:J92, except the AND Function must be used, see Message when you click in cell C93

    With regard to my point 2, the formula in C97, must produce the same result as C95, the only difference to the formula, is that the IF function must be used

    It would be appreciated if you could kindly assist me

    Regards

    Howard

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    [quote name='HowardC' post='774459' date='09-May-2009 19:59']With regard to my point 1 , the formula in C93:J93, must produce the same result as in C92:J92, except the AND Function must be used, see Message when you click in cell C93

    With regard to my point 2, the formula in C97, must produce the same result as C95, the only difference to the formula, is that the IF function must be used[/quote]
    What strange requirements! Is this an attempt to get someone to do your homework for you?

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    Howard

    These are questions based from this book or something similar.

    These questions are specifically about financial management and whilst Loungers are happy to answer functional questions about AND statements you can't expect us to be all financial experts.

    However, if you were to pose a question without reference to Christopher Buzzard and Mike Ehrhardt's work we maybe able to help you
    Jerry

  6. #6
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    [quote name='Jezza' post='774485' date='09-May-2009 23:40']Howard

    These are questions based from this book or something similar.

    These questions are specifically about financial management and whilst Loungers are happy to answer functional questions about AND statements you can't expect us to be all financial experts.

    However, if you were to pose a question without reference to Christopher Buzzard and Mike Ehrhardt's work we maybe able to help you[/quote]


    Attached please find amended spreadsheet. I have managed to solve the logical test using the AND function C20:J20 . have used the Index function in cell C24:J24, but would like this changed to an IF Nested Function . It would be appreciated if you could assist

    Regards

    Howard
    Attached Files Attached Files

Posting Permissions

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