Thread: [Solved] IF Formula problems
View Single Post
 
Old 02-16-2015, 07:44 PM
mikeb2 mikeb2 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2015
Location: Arizona
Posts: 1
mikeb2 is on a distinguished road
Default IF Formula problems

Service ContractsPenetrationAverage Gross49%5%$999 5%50%6%$1,000 6%55%7%$1,200 7%60%8%$1,300 8%70%10%$1,40010%


SoldGrossAverage%Penetration %Gross %Total %EarningsService Contracts50$53,500$1,07052%7%7%14%$7,490.00


I am trying to write an IF formula using this spreadsheet. It looks to me like it is written correctly but it is rounding up somehow, i.e. 54% returns the 55% Value. It works at the lower percentages but then returns an error.
My Formulas are
=IF(H36<=B5,C5,IF(H36<=B6,C6,IF(H36<=B7,C7,IF(H36< =B8,C8,IF(H36<=B9,C9)))))

=IF(G36<=F5,G5,IF(G36<=F6,G6,IF(G36<=F7,G7,IF(G36< =F9,G9))))

I am unclear how to make it work. I have many other tables on the sheet that I would like to have figure the results as well but I am stuck with the first table. Thanks for any help that I might get. Mike
Reply With Quote