Excel formatting question?

tilldeath · Oct 29, 2012, 01:21 AM

So I have a total amount in cell D16, then below that I need to input a formula that is 1/4 of cell D16. What do I enter here? =D16/.25??????? It gives me a fractional value and I need it in decimal Ie.106 7/8 I need it to come out 106.875 with it rounded to 106.88. Any help?

micropage7 · Oct 29, 2012, 01:50 AM

what about format cell>number and setting number from that

newtekie1 · Oct 29, 2012, 01:59 AM

This should work:

Code:

=ROUND((D16/4), 2)

1freedude · Oct 29, 2012, 02:07 AM

also, your math is wrong. It would be d16*.25

drdeathx · Oct 29, 2012, 02:46 AM

D16*.25

Your welcome

tilldeath · Oct 29, 2012, 10:18 PM

thx guys, =D16*.25 worked fine but kept giving me a fractional answer until I changed the formatting to dollars and then it converted it to decimal. Feel semi retarded

Oct 29, 2012, 01:21 AM	#1
tilldeath Join Date: Feb 2011 Posts: 182 (0.22/day) Thanks: 28 Thanked 7 Times in 6 Posts	Excel formatting question? So I have a total amount in cell D16, then below that I need to input a formula that is 1/4 of cell D16. What do I enter here? =D16/.25??????? It gives me a fractional value and I need it in decimal Ie.106 7/8 I need it to come out 106.875 with it rounded to 106.88. Any help?

Oct 29, 2012, 01:50 AM	#2
micropage7 Join Date: Mar 2010 Location: Jakarta, Indonesia Posts: 3,674 (3.19/day) Thanks: 189 Thanked 835 Times in 549 Posts System Specs	what about format cell>number and setting number from that __________________ :: New Cases, Tips And All About Your Cases Visit CaseGear :: Don't Ever Ask About Love And Honesty That You Don't Ever Have

System Name:	micropage7
Processor:	phenom x4 955 Black Edition @ Stock
Motherboard:	Asrock 990FX
Cooling:	Xigmatek HDT-SD964
Memory:	8Gb Team Xtreem DDR3
Video Card:	Radeon 5570 CrossFire
Hard Disk:	Seagate 160Gb, 250Gb & 500Gb SATA
Optical Drive:	LG DVDRW, Samsung Combo
CRT/LCD Model:	LG 19 inch LCD Wide Screen
Case:	Lian Li PC-7FNW
Sound Card:	Creative Audigy Value
PSU:	VenomRX Red Diamond 650 Watt
Software:	Windows 7 64-bit
Benchmarks:	Classified

Oct 29, 2012, 01:59 AM	#3
newtekie1 Semi-Retired Folder Join Date: Nov 2005 Location: Indiana Posts: 17,741 (6.49/day) Thanks: 780 Thanked 5,113 Times in 3,704 Posts System Specs	This should work: Code: =ROUND((D16/4), 2) __________________ Rig1: System Specs. Rig2: A8-5600K@4.4GHz / AsRock FM2A75 Pro4 / 8GB Corsair DDR3-1600 9-9-9-24 / HD7560D / Samsung DVD-Burner / 1.5TB WD Green + 3x3TB WD RED in RAID5 Rig3: Athlon X2 4200+ / M4A79 Deluxe / 4GB G.Skill Pi DDR2-800 4-4-4-12 / GT430 / Sony DVD-Burner / 500GB WD Rig4: Phenom II x6 1605T @ 3.6GHz / Asus M5A99X Evo / 8GB PNY DDR3-1600 9-9-9 / GTX470 & GTX470 / Samsung DVD-Burner / 1.5TB Seagate

Processor:	Intel Core i7 875K@4.0GHz(200x20)
Motherboard:	eVGA P55 FTW 200
Cooling:	Thermalright Ultra-120 Extreme w/ Corsair SP120 High Performance Edition
Memory:	8GB Corsair DDR3-1600 7-7-7-20
Video Card:	ASUS GTX 670 4GB DirectCU II @ 1015/3600
Hard Disk:	1TB Seagate 7200.12(OS), 3x 1.5TB Seagate 7200.11 in RAID 5
Optical Drive:	Lite-On Blu-Ray Combo Drive IHES108
CRT/LCD Model:	HP 25" 2509m 1080p LCD
Case:	Lian-Li Lancool Metal Boned K7 w/ Windowed Side Panel
Sound Card:	Onboard is good enough for me
PSU:	Corsair HX850
Software:	Windows 7 x64 Professional

Oct 29, 2012, 02:07 AM	#4
1freedude Join Date: Nov 2007 Posts: 451 (0.22/day) Thanks: 207 Thanked 120 Times in 90 Posts System Specs	also, your math is wrong. It would be d16*.25

Processor:	i7 920
Motherboard:	SABERTOOTH X58
Cooling:	Fans
Memory:	24 GB Kingston HyperX 1600
Video Card:	MSi GTX 260 Twin Frozr, MSI GTX 260 Max OC
Hard Disk:	spinners
Optical Drive:	LG Supermulti SATA
CRT/LCD Model:	Dell 2001F
Case:	Robela
Sound Card:	onboard
PSU:	X750
Software:	win 7 x64 pro
Benchmarks:	fast...

Oct 29, 2012, 02:46 AM	#5
drdeathx Join Date: May 2009 Location: Chicago burbs Posts: 1,458 (0.99/day) Thanks: 39 Thanked 322 Times in 262 Posts System Specs	D16*.25 Your welcome

System Name:	Halloween Boo!
Processor:	Intel Core i7 3770K
Motherboard:	Gigabyte Z77-Up7
Cooling:	Custom Water/ Thermalchill TA 120.3/ Swiftech Apogeee XT/ MCP655/ Swiftech M icrores/ XSPC RX 240
Memory:	16G G.Skill trident 2400MHz
Video Card:	3 x Radeon 7970
Hard Disk:	OCZ Revo Drive 240G
Optical Drive:	Asus
CRT/LCD Model:	24 inch Viewsonic
Case:	Phobia WayCoolIt Test Bench
PSU:	Nexus 1100 watt

Oct 29, 2012, 10:18 PM	#6
tilldeath Join Date: Feb 2011 Posts: 182 (0.22/day) Thanks: 28 Thanked 7 Times in 6 Posts	thx guys, =D16*.25 worked fine but kept giving me a fractional answer until I changed the formatting to dollars and then it converted it to decimal. Feel semi retarded

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel question	JanJan	General Software	10	Feb 17, 2011 08:52 AM
Noob Excel Question	OrbitzXT	General Software	2	Sep 21, 2010 05:19 PM
Microsoft Excel question	ste2425	General Software	5	Apr 23, 2010 04:44 PM
HDD Formatting Question	wolf2009	General Software	7	May 21, 2009 04:15 PM
Daft question about number formatting in Excel 2007	rheged	General Software	0	Jun 25, 2008 08:20 PM