#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi
please post a sample sheet ( no pics please) - Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
scaling problems | bestgepeto | Word | 3 | 02-22-2012 05:31 PM |
Word problems | DoctorT | Word | 6 | 12-21-2011 11:23 AM |
Problems in Word. | Emerogork | Office | 1 | 09-14-2011 08:07 AM |
pst problems - HELP!! | hussar | Outlook | 1 | 03-07-2011 06:41 PM |
Problems with Bcc | beadsworldwide | Outlook | 3 | 02-01-2006 03:34 PM |