Results 1 to 7 of 7

Modify IF Output based on Result

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-24-2010
    Location
    London England
    MS-Off Ver
    Excel 2003
    Posts
    345

    Modify IF Output based on Result

    Hi,

    I have the following formula in cell G11

    =IF(G10<>"",G10-1255555,"")
    I would also like to add to that, in english, if the answer to G10-1255555 is 0 or less, then write NA.

    does anyone know how to do this please?

    Thank you
    Last edited by DonkeyOte; 01-12-2011 at 11:53 AM.

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