Results 1 to 4 of 4

Removing unwanted numbers after decimal point

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Removing unwanted numbers after decimal point

    =IF(ISERROR(A2*B2/C2+A2),"",(A2*B2/C2+A2))

    The above formula works perfectly for my needs. However, I've tried to include the word "WON" in the answer cells (D) by including = "WON " & but as you can see some cells return answers with several numbers after the decimal point even though I've reduced the number to zero. Is there a way round this please?
    Many thanks.
    Attached Files Attached Files
    Last edited by tom hatten; 09-03-2012 at 01:57 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1