I am trying to create a formula with the following numbers. Base of $180,000 in cell A1 and base of 75% in cell A2. If I change cell A1 to say any number over $180,000, then I want cell A2 to decrease by 1/10 of a percentage point for every $1,000 increase in cell A1. So if I change cell A1 to $196,342, then I want cell A2 to report 73.4% & so on? Any help would be much appreciated. Thanks!
Try:
=75%-(A1-180000)/10^6
Quang PT
In cell A2 enter the formula =0.75+((INT(180000-A1)/1000)*0.001)
I just tried both to see if they are the same & they are! Thanks guys for the really really fast replies! One quick question for bebo.....Why the 10^6? Just trying to understand. Thanks!
A1 increases 16342 and A2 decreases 1.6% = 16342/1000000 = (A1-180000)/10^6
So A2 = 75%-1.6% = 75% - (A1-180000)/10^6
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks