Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I am trying to do some calculations on some date fields and it will not produce a result in the field, I am using the following functions

    =IF(AND(AP$3>=$J6,AP$3<=$K6),$M6/$L6,"")

    But get a result error.

    Attached is an example sheet with all field available - formula in in the cells in yellow.

    Any help appreciated.

    Regards

    Mike
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Mike,

    If you widen the columns, you do have results in those cells, and I do not see any errors. Am I missing something?

    [attachment=83646:070509.GIF]
    Attached Images Attached Images

  3. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    It might not even apply to the problem at hand, but I use this site for a reference whenever I have date arithmetic to do: http://www.cpearson.com/excel/datearith.htm
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='mikeyt' post='774062' date='07-May-2009 17:58']=IF(AND(AP$3>=$J6,AP$3<=$K6),$M6/$L6,"")

    But get a result error.

    Attached is an example sheet with all field available - formula in in the cells in yellow.

    Any help appreciated.

    Regards

    Mike[/quote]

    Mike

    nothing wrong with the formula and the result are correct in your example.

    what is the error you get?
    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

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='franciz' post='774272' date='08-May-2009 11:32']Mike

    nothing wrong with the formula and the result are correct in your example.

    what is the error you get?[/quote]

    Hi All,

    I am really sorry, I had a very senior moment.

    The result is there.

    Regards

    Mike

Posting Permissions

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