Results 1 to 4 of 4

IF statement unable to process negatives

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298

    IF statement unable to process negatives

    Hello,

    I have a problem with an IF statement, i have a "sheet value" and a "Revenue" value, the sheet value may be higher or lower than the revenue value, thus giving either a + or - value, i'm trying to get a return if the difference between the sheet and revenue is less than 10%, i have tried my own formula but it won't work with negative values, i have attached a worksheet with an example

    thanks reg
    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