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, USA
    Posts
    881
    Thanks
    147
    Thanked 11 Times in 10 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
  •