Results 1 to 4 of 4

Percentage formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2009
    Location
    North Carolina
    MS-Off Ver
    2010
    Posts
    10

    Percentage formula

    Good morning,

    I am looking for some help:

    FIRST Problem
    Working with Columns H I K & L
    Want to compare sales in H & I and result to appear in K (RED or Green)
    I figured that part out however, there will be times when I will not have information to enter in Column I, so it will be $0.00. This of course will skew the data and the percentages in L. Can someone help with the correct formula in K (=IF(H2>I2, TRUE,FALSE) to account for the above?


    SECOND PROBLEM
    Working with Column O (comparing H&I) and Column P (comapring G&I)
    I am tyring to figure out how to calculate our percentages of Wins (Based on using the data in columns. I am not sure how to do this.

    Spreadsheet attached.

    Thanks in advance
    Jason
    Attached Files Attached Files
    Last edited by jcutler0902; 08-20-2009 at 11:04 AM. Reason: Modifying the thread title

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