• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Excel formatting question?

tilldeath

New Member
Joined
Feb 8, 2011
Messages
200 (0.08/day)
Likes
5
#1
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?
 
Joined
Mar 26, 2010
Messages
7,680 (2.69/day)
Likes
1,998
Location
Jakarta, Indonesia
System Name micropage7
Processor Intel G4400
Motherboard MSI B150M Bazooka D3
Cooling Stock ( Lapped )
Memory 16 Gb Team Xtreem DDR3
Video Card(s) Nvidia GTX460
Storage Seagate 1 TB, 5oo Gb and SSD A-Data 128 Gb
Display(s) LG 19 inch LCD Wide Screen
Case HP dx6120 MT
Audio Device(s) Stock
Power Supply Be Quiet 600 Watt
Software Windows 7 64-bit
Benchmark Scores Classified
#2
what about format cell>number and setting number from that
 

newtekie1

Semi-Retired Folder
Joined
Nov 22, 2005
Messages
24,413 (5.50/day)
Likes
10,549
Location
Indiana, USA
Processor Intel Core i7 8700K@4.8GHz(Quick and dirty)
Motherboard AsRock Z370 Taichi
Cooling Corsair H110i GTX
Memory 32GB Corsair DDR4-3000
Video Card(s) PNY XLR8 GTX1060 6GB
Storage 480GB Crucial MX200 + 2TB Seagate Solid State Hybrid Drive with 128GB OCZ Synapse SSD Cache
Display(s) QNIX QX2710 1440p@120Hz
Case Fractal Design Define S
Audio Device(s) Onboard is good enough for me
Power Supply Corsair HX850
Software Windows 10 Pro x64
#3
This should work:
Code:
=ROUND((D16/4), 2)
 
Joined
Nov 16, 2007
Messages
557 (0.15/day)
Likes
118
Processor i7 920
Motherboard SABERTOOTH X58
Cooling Fans
Memory 24 GB Kingston HyperX 1600
Video Card(s) gtx460
Storage spinners
Display(s) Dell 2001F
Case Lian Li
Audio Device(s) onboard
Power Supply X750
Software win 7 x64 pro
Benchmark Scores fast...
#4
also, your math is wrong. It would be d16*.25
 
Joined
May 14, 2009
Messages
2,132 (0.67/day)
Likes
477
Location
Chicago burbs
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(s) 3 x Radeon 7970
Storage OCZ Revo Drive 240G
Display(s) 24 inch Viewsonic
Case Phobia WayCoolIt Test Bench
Power Supply Nexus 1100 watt
#5
D16*.25

Your welcome
 

tilldeath

New Member
Joined
Feb 8, 2011
Messages
200 (0.08/day)
Likes
5
#6
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:nutkick: