Results 1 to 3 of 3

round function with if function

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    Dubai,United Arab Emiretas
    MS-Off Ver
    Excel 2003
    Posts
    36

    round function with if function

    I have the following IF Function and need to be able to use the ROUND Function within this to round the figures to 0. can this be done?


    IFERROR(IF(D14-E14=0,"Stable",D14-E14),IF(AND(E14="-",D14="-"),"NR",IF(D14="-","Gain","Dropped")))

    attachment will show example

    Thanks
    Attached Files Attached Files

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