Percentage formula

**jcutler0902** · 08-20-2009, 10:09 AM

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

**shg** · 08-20-2009, 10:36 AM

Please take a few minutes to read the forum rules, and then amend your thread title appropriately.

Thanks.

**shg** · 08-20-2009, 02:42 PM

Thanks.

For the conditional formatting formula, try =AND(COUNT(H2:I2)=2, H2<I2)

In L2, =IF(COUNT(H2:I2)<2, "", I2/H2 - 1

**jcutler0902** · 08-20-2009, 08:58 PM

Thank you for that..I am still a little confused.

In L2, =IF(COUNT(H2:I2)<2, "", I2/H2 - 1 --- I added this formula as a third condition (see below).

=IF(G2<I2, TRUE,FALSE) = Green
=IF(G2>I2, TRUE,FALSE) = Red
=IF(COUNT(H2:I2)<2), "", I2/H2 = Yellow - but it is not doing it

I was not sure where to input: =AND(COUNT(H2:I2)=2, H2<I2)?

Thanks!
JC