Results 1 to 16 of 16

USING LOGIC 1's AND O's WITH FORMULAS

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-24-2009
    Location
    SCOTLAND
    MS-Off Ver
    Excel Version 2308
    Posts
    151

    USING LOGIC 1's AND O's WITH FORMULAS

    The problem is that I can’t find a way of converting the logic 1’s or 0’s resulting from the IF formulas used in F13, 20 and 25 to a value where I can compare the results of the aforementioned cells and display OP, SOP or WI in C27 which corresponds to the table in columns L to O.
    Any guidance on how to solve my spreadsheet problem or suggest a better method of achieving the same result would be much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Need help linking using logic formulas
    By luurkin in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 07:09 PM
  2. Logic formulas
    By isjones in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2011, 11:40 AM
  3. Coin flipping - logic formulas
    By isjones in forum Excel General
    Replies: 0
    Last Post: 11-01-2011, 12:13 PM
  4. Help with inserting logic into formulas
    By ah432 in forum Excel General
    Replies: 1
    Last Post: 11-22-2010, 11:05 AM
  5. Several formulas in one cell + Logic fail
    By varmgang in forum Excel General
    Replies: 3
    Last Post: 05-03-2009, 07:11 PM

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