Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2015, 07:44 PM
mikeb2 mikeb2 is offline IF Formula problems Windows 7 64bit IF Formula problems Office 2010 64bit
Novice
IF Formula problems
 
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
  #2  
Old 02-17-2015, 06:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now IF Formula problems Windows 7 64bit IF Formula problems Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
scaling problems bestgepeto Word 3 02-22-2012 05:31 PM
IF Formula problems Word problems DoctorT Word 6 12-21-2011 11:23 AM
IF Formula problems Problems in Word. Emerogork Office 1 09-14-2011 08:07 AM
IF Formula problems pst problems - HELP!! hussar Outlook 1 03-07-2011 06:41 PM
IF Formula problems Problems with Bcc beadsworldwide Outlook 3 02-01-2006 03:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft