I am about to poke my eyes out trying to get a formula to work! Does anyone know of a good site that has a "cheat sheet" for formulas? Right now I am trying to do an IF formula and I think I need to go to bed because I can't get it right... For the record before this class I knew basic excel The formula I am trying to write ( and maybe im stupid because im tired or have been working on this stuff for 5 hours) is If the difference between 29,960 and 27968 is 30% or less return value yes if more than 30% return value no Obviously its 8% difference but I cant write the formula right!!! I am sure its so simple and its just because my eyes hurt that I cant get it right.. Any help?
I would think this way cell E2 contains 29,960 cell F2 contains 27968 cell G2 contains =IF(((E2-F2)/E2)<=0.3,TRUE,FALSE) but that can't be right because E2 - F2 = 1992 29,960 - 27968 = 1992 then divide that by E2 1992 / 29960 = 0.066488652 which is 6.65 % not 8 % so I don't know
Where did you get 8% from? Are you asking if the difference is more than 30% of the larger number or 30% of the lesser number? The difference will be slight but it is still a difference.
Try these sites- Excel Tips, Excel Tutorials and Excel Techniques Excel Charts and Graphs Tutorial - How to Make and Create, MS 2007
note to self: Do not write threads when your tired and your eye balls hurt! The correct numbers are : 29280-26968=2313/29280=0.078 rounded up to 8%
Here are the instructions: Insert an IF function that evaluates the difference between the total amount you would end up paying if you took the loan that resulted in the lowest monthly payment and the actual purchase price of the car. Return the value YES if the difference is 30% or less; return the value NO if the difference is more than 30%. Financed amount is 29280 Actual purchased amount is 26968 The difference is about 8% which would mean the value should return yes but it returns no!
I dont know if you found the solution but here it is: if B1=29280 and C1=26968 then Code: =IF(ROUND(((B1-C1)/B1)*100,0)<30,"YES","NO") Btw, this rounds up the percentage so if it is 7,7238812% then it will be rounded up to 8%! If you want me to explain what i did just leave a reply
I had not found the solution.... I think I am in love with you....im kidding! Yes please explain as that is the only way to learn! BTW it worked!
I say you should divide by C1 not B1 if B1 = 100 (this is the loan price with interest) and C1 = 30 (this is the actual cash purchase price) then what % do you expect to see ? the price difference is 70 dollars so if you say 70 / B1 (which is 70/100) you get 70 % but if you say 70 / C1 (which is 70/30) you get 233 % dividing by C1 tells you that you end up paying 233 % more if you take out a loan than you do if you pay with cash price