Results 1 to 4 of 4

alternate is statement

Threaded View

  1. #1
    Registered User
    Join Date
    12-09-2008
    Location
    Australia
    Posts
    27

    alternate is statement

    i have attached a copy of an excel file and if you look at the end i am trying to write an IF statement that reads if J = "2-0" then column M = 12-(K) or 12--4 so answer is 16 and then column N = -column M or -16 and then if J = "2-1" then M = 6-(K) or 6--0 = 6 and then N = -M .....

    so if J was "2-1" and (K) -4 then the answer given for column M would be 6--4=10 and column N = -10

    Much appreciated
    Troy
    Attached Files Attached Files
    Last edited by percivaltroy; 05-13-2009 at 01:02 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