Round Ceiling
Round Ceiling
How do I add a formula to excel to round a number to the nearest 100?
How do I add a formula to excel to round a number to the nearest 100?
Eg 1445 would need to be rounded down to 1400 or 1175 would become 1200?
The numbers are already integers. Floor and ceiling formula seem almost to work, but I need to to automatically round up if 50 or over and round down if 49 or under.
Thanks
=IF(MOD(A1,100)<50, FLOOR(A1,100),CEILING(A1,100))
 Polk Audio RC60i In-Ceiling / In-Wall Speakers (Pair, White) List Price: Sale Price: $88.88 You save: $161.07 (64%)  Eligible for free shipping!Availability: Usually ships in 24 hours  |
 JBL SP8CII 2-Way, Round 8-Inch In-Ceiling Speaker with Swivel Mount Tweeter (Pair) List Price: Sale Price: $190.33 You save: $89.66 (32%) Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 Polk Audio TC80i Round 2-Way 8-Inch In-Ceiling Loudspeaker (Single, White) List Price: Sale Price: $299.95 You save: $20.04 (6%) Eligible for free shipping!Availability: Usually ships in 3-4 business days |
 Polk Audio RC80i 2-Way In-Ceiling Speakers (Pair, White) List Price: Sale Price: $129.99 You save: $199.96 (61%) Eligible for free shipping!Availability: Usually ships in 24 hours |
 Pyle Home PDIC81RD 8-Inch Two-Way In-Ceiling Speaker System List Price: Sale Price: $42.70 You save: $23.88 (36%) Eligible for free shipping!Availability: Usually ships in 24 hours |
 Definitive Technology UIW63/A Round In-Ceiling Speakers (Pair, White) Sale Price: $278.00 Eligible for free shipping!Availability: Usually ships in 24 hours |
 Architech Pro Series Ap-615 LCRs 6.5-Inch 2-Way Round Angled In-Ceiling LCR Loudspeaker List Price: Sale Price: $49.99 You save: $40.00 (44%) Eligible for free shipping!Availability: Usually ships in 24 hours |
 JBL SP6CII 2-way, Round 6.5" In-Ceiling Speaker with Swivel Mount Tweeter (Pair) List Price: Sale Price: $172.26 You save: $57.73 (25%) Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 THIEL HigherPlane 1.2 High Performance Surround Round In-Ceiling Loudspeaker ( Front/Center, Single) Sale Price: $990.00 Eligible for free shipping!Availability: Usually ships in 24 hours |
 Architech Pro Series Ap-815 LCRs 8-Inch 2-Way Round Angled In-Ceiling LCR Loudspeaker List Price: Sale Price: $59.99 You save: $40.00 (40%) Eligible for free shipping!Availability: Usually ships in 24 hours |
09. Ceiling Fan. Living-Room. 1st Floor. Round Rock TX
