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?
-
Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.
Excel formatting question?
- Thread starter tilldeath
- Start date
- Joined
- Mar 26, 2010
- Messages
- 9,777 (1.90/day)
- Location
- Jakarta, Indonesia
| System Name | micropage7 |
|---|---|
| Processor | Intel Xeon X3470 |
| Motherboard | Gigabyte Technology Co. Ltd. P55A-UD3R (Socket 1156) |
| Cooling | Enermax ETS-T40F |
| Memory | Samsung 8.00GB Dual-Channel DDR3 |
| Video Card(s) | NVIDIA Quadro FX 1800 |
| Storage | V-GEN03AS18EU120GB, Seagate 2 x 1TB and Seagate 4TB |
| Display(s) | Samsung 21 inch LCD Wide Screen |
| Case | Icute Super 18 |
| Audio Device(s) | Auzentech X-Fi Forte |
| Power Supply | Silverstone 600 Watt |
| Mouse | Logitech G502 |
| Keyboard | Sades Excalibur + Taihao keycaps |
| Software | Win 7 64-bit |
| Benchmark Scores | Classified |
what about format cell>number and setting number from that
newtekie1
Semi-Retired Folder
- Joined
- Nov 22, 2005
- Messages
- 28,472 (4.24/day)
- Location
- Indiana, USA
| Processor | Intel Core i7 10850K@5.2GHz |
|---|---|
| Motherboard | AsRock Z470 Taichi |
| Cooling | Corsair H115i Pro w/ Noctua NF-A14 Fans |
| Memory | 32GB DDR4-3600 |
| Video Card(s) | RTX 2070 Super |
| Storage | 500GB SX8200 Pro + 8TB with 1TB SSD Cache |
| Display(s) | Acer Nitro VG280K 4K 28" |
| Case | Fractal Design Define S |
| Audio Device(s) | Onboard is good enough for me |
| Power Supply | eVGA SuperNOVA 1000w G3 |
| Software | Windows 10 Pro x64 |
This should work:
Code:
=ROUND((D16/4), 2)
- Joined
- Nov 16, 2007
- Messages
- 1,166 (0.19/day)
- Location
- Hampton Roads
| Processor | Xeon x5650 |
|---|---|
| Motherboard | SABERTOOTH X58 |
| Cooling | Fans |
| Memory | 24 GB Kingston HyperX 1600 |
| Video Card(s) | GTX 1060 3GB |
| Storage | small ssd |
| Display(s) | Dell 2001F, BenQ short throw |
| Case | Lian Li |
| Audio Device(s) | onboard |
| Power Supply | X750 |
| Software | Mint 19.3, Win 10 |
| Benchmark Scores | not so fast... |
also, your math is wrong. It would be d16*.25
- Joined
- May 14, 2009
- Messages
- 2,132 (0.39/day)
- 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 |
D16*.25
Your welcome
Your welcome
