Results 1 to 11 of 11

assuming its nested if's i need

Threaded View

  1. 07-21-2015, 01:21 AM #1
    Patcheen
    Patcheen is offline
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    assuming its nested if's i need

    im trying to get a next result on a sheet as in either a win, lose or draw based on the Percentage of games either won, drawn or lost but cant get it to compute, i know its something im doing wrong.......

    Here is the formula im using.......



    =IF(G5>H5+I5,"win",IF(H5>G5+I5,"draw",IF(I5>H5+G5,"lose")))
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stop Excel from assuming data is a date
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2014, 12:10 PM
  2. [SOLVED] File Download Name assuming Thread Title as File Name Windows 2007
    By jaslake in forum Suggestions for Improvement
    Replies: 10
    Last Post: 03-19-2014, 01:07 PM
  3. [SOLVED] Excel 2007 : graphing a continuous data series/assuming zeros
    By Taft584 in forum Excel General
    Replies: 5
    Last Post: 04-29-2012, 05:43 PM
  4. Excel 2008 : How to count dates assuming that the year changes?
    By Zsidat in forum Excel General
    Replies: 2
    Last Post: 03-09-2012, 11:01 AM
  5. How to count dates assuming that the year changes?
    By Zsidat in forum Excel General
    Replies: 5
    Last Post: 03-08-2012, 06:34 PM
  6. String assuming date format
    By humantripod in forum Excel General
    Replies: 2
    Last Post: 12-13-2006, 06:36 PM
  7. average-range assuming all cells have a value > 0
    By Renee - California in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1