as a dollar value increases, a percentage value decreases by 1/10 for every $1000

**cffndncr** · 03-11-2014, 12:01 AM

In cell A2 enter the formula =0.75+((INT(180000-A1)/1000)*0.001)

**jaCambro** · 03-11-2014, 12:08 AM

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!

as a dollar value increases, a percentage value decreases by 1/10 for every $1000

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: as a dollar value increases, a percentage value decreases by 1/10 for every $1000

Re: as a dollar value increases, a percentage value decreases by 1/10 for every $1000

Thread Information

Users Browsing this Thread

Similar Threads

Would like to utilize text-to-speech when a cell increases or decreases in value

[SOLVED] Add Up/Down Arrows to a Table to increases/decreases in Variances

counting increases and decreases across rows

Excel 2007 : Recognising increases and decreases with a zero figure

increases/decreases from a quote to a booking

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions