Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I wrote a formula to 1>first check the value(s) in a cell and if it does not match 78015 then of multiply one cell to another cell. the multiplication portion of the formula requires error capturing. if the cell does match the record a 0.

    Here is the original formula: '=IF(ISERROR(+ROUND($M46*AB46,2)),"-",(+ROUND($M46*AB46,2)))

    I changed it to test for the match: '=IF(F46=78015,0,IF(ISERROR(+ROUND($M46*AB46,2)),"-",(+ROUND($M46*AB46,2))))


    However nothing happens, the result cell remains the same.

    Any insights??

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Not sure what you mean, basic principle of formula appears to work ok
    see picture below

    [attachment=88606:IFERROR.jpg]

    I did strip out the not needed +'s on the Round
    You might need to post the spreadsheet or a sanitized version.
    Attached Images Attached Images
    Andrew

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thank you.


Posting Permissions

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