Results 1 to 2 of 2

Nested IF Statement

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2007
    Posts
    8

    Question Nested IF Statement

    I'm having great difficulty with my cell E40 formula.

    (The formula in cell E38 works perfectly).

    I am trying to prevent a negative number from popping up in E40.
    A negative amount always pops up if the case threshold of 50 (in cell L1) is not met.
    I only want the positive number to appear.


    I have tried to insert the usual "greater than and less than" symbols in the formula and cannot seem to make the formula work.
    And I have handwritten out the formula and still cannot get it to work.
    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