Current Events > Need a little help with a formula for Google Sheets/Excel

Topic List	Page List: 1
Blackstar110 08/06/17 10:17:47 PM #1:	Essentially, I'm looking for a formula where Column A = numbers Column B = the percentage the number in column A is out of $167,000,000 So, for example, if I plunked in $1,670,000 into column A, "1%" would pop up in column B. Any way to set such a formula? --- -Shred <cite>Blackstar110 posted [p:884312788] in Need a lit... [t:75645078]...</cite> <quote>Essentially, I'm looking for a formula where Column A = numbers Column B = the percentage the number in column A is out of $167,000,000 So, for example, if I plunked in $1,670,000 into column A, "1%" would pop up in column B. Any way to set such a formula?</quote> ... Copied to Clipboard!
WaterLink 08/06/17 10:19:46 PM #2:	=A1/167000000 Then drag it down. Change the category of the cells in the column to percentage --- No one sings like you anymore <cite>WaterLink posted [p:884312886] in Need a lit... [t:75645078]...</cite> <quote>=A1/167000000 Then drag it down. Change the category of the cells in the column to percentage</quote> ... Copied to Clipboard!
dodokiki 08/06/17 10:21:17 PM #3:	For column B have formula `=A#/1670000` where # means some cell number then set format as a percentage. --- Gamefaqs Confessions Form: https://goo.gl/iyqTeU PM me for list of all and uncensored CE confessions. <cite>dodokiki posted [p:884312965] in Need a lit... [t:75645078]...</cite> <quote>For column B have formula =A#/1670000 where # means some cell number then set format as a percentage.</quote> ... Copied to Clipboard!
brandunh11 08/06/17 10:21:45 PM #4:	Cell b1 should be =a1/167000000 Copy/drag that formula down in column b. Be sure to set the formatting in column b to percentages --- http://i.imgur.com/MDQBi2C.jpg http://tinyurl.com/TooMuchMonta <cite>brandunh11 posted [p:884312983] in Need a lit... [t:75645078]...</cite> <quote>Cell b1 should be =a1/167000000 Copy/drag that formula down in column b. Be sure to set the formatting in column b to percentages</quote> ... Copied to Clipboard!
Blackstar110 08/06/17 10:23:46 PM #5:	WaterLink posted... =A1/167000000 Then drag it down. Change the category of the cells in the column to percentage Know who rocks? ~~you~~ --- -Shred <cite>Blackstar110 posted [p:884313093] in Need a lit... [t:75645078]...</cite> <quote><cite>WaterLink posted...</cite> <quote>=A1/167000000 Then drag it down. Change the category of the cells in the column to percentage</quote> Know who rocks? you</quote> ... Copied to Clipboard!
Topic List	Page List: 1