Set Round
 |
 |
10pcs Flat Round Vintage Clear Glass Cabochon Findings Fit Settings 10x10mm GC01 |  |
1 Bid | US $.99 | 17m |
 |
z7837 Ladys Round Mother of Pearl Beads Dangle Clasp Necklace Earrings Set Hot | |
2 Bids | US $1.04 | 24m |
 |
Grand Round Austria Crystal Set Necklace Earrings Jewellery New | |
0 Bid | US $7.85 | 29m |
How to set a farmula in excel which round off the amount to next divisible of 10?
example suppose values = 63, 65.25, 69
the round off amount should be = 70
another example suppose value = 31, 37 etc.
the round off amount should be = 40
=ROUNDUP(63, -1)
This will give the answer of 70.
=ROUNDDOWN(63, -1)
This gives 60.
=ROUND(63, -1)
This gives 60 as well.
A positive number makes the number round to # decimal places. Likewise, an negative number will make the number round to a power of 10.
Also, in your question, it is spelled formula, not farmula (no offense)
|
|
10pcs Flat Round Vintage Clear Glass Cabochon Findings Fit Settings 10x10mm GC01 | |
1 Bid | US $.99 | 17m |
|
z7837 Ladys Round Mother of Pearl Beads Dangle Clasp Necklace Earrings Set Hot | |
2 Bids | US $1.04 | 24m |
|
Grand Round Austria Crystal Set Necklace Earrings Jewellery New | |
0 Bid | US $7.85 | 29m |
 |
230 pieces Round Cut Acrylic Rhinestones 3mm Random Color Mix Set | |
0 Bid | US $.98 | 38m |
 |
z7832 Ladys Round Red Mother of Pearl Beads Dangle Clasp Necklace Earrings Set | |
2 Bids | US $1.04 | 40m |
 |
Set of 5 Chinese White Cultured FWP 9 11mm Round predrilled Jewelry Television | |
 |
US $17.98 | 41m |
 |
1set 10mm Red Ruby Gemstone Round Necklace 18 Bracelet 75 Earring | |
6 Bids | US $3.25 | 49m |
 |
130 ct Round Diamond Bezel Set Engagement Ring 14k White Gold | |
0 Bid | US $2,530.00 | 49m |
 |
ENGAGEMENT WEDDING RING SET SIMULATED DIAMOND MARQUIS BAGUETTE ROUNDS SIZE 8 | |
1 Bid | US $199.99 | 59m |
 |
Diamond Heart Shaped Pendant white gold set w 24 Round Brilliant Cut Diamonds | |
|
US $100.00 | 1h |
 |
Violet Crystal Round Flower Bead Necklace Bracelet Earring Jewelry 1Sets Gift | |
0 Bid | US $4.99 | 1h 2m |
 |
ELEGANT STERLING SILVER FACETED ROUND GARNET BASEL SETTING DESIGN PENDANT | |
6 Bids | US $15.50 | 1h 9m |
 |
Prong Set Genuine Round White Topaz Two Hearts Marcasite Sterling Silver Ring | |
0 Bid | US $24.99 | 1h 13m |
 |
003 CARAT H COLOR SI1 ROUND NATURAL LOOSE DIAMOND FOR JEWELRY SETTING 205 117 | |
0 Bid | US $14.99 | 1h 16m |
 |
Vintage Rhinestone Brooch Round Multi color crystal AB stones prong set 50s | |
0 Bid | US $9.95 | 1h 26m |
 |
1ct Round Yellow Gold Filled Wedding Engagement Ring Set Q Valentines Gift B21 | |
1 Bid | US $7.74 | 1h 28m |
 |
Round Amethyst Wedding Bridal Set Necklace Earrings Jewellery | |
0 Bid | US $7.85 | 1h 32m |
 |
Stacker Ring with Round Cut Montana Blue CZ in a Channel Setting Size6 MF112 | |
0 Bid | US $24.00 | 1h 32m |
 |
Y1204S26 set silver 5 round pendant chain bracelet necklace | |
0 Bid | US $.99 | 1h 33m |
 |
Peacock Green Crystal Round Flower Bead Necklace Bracelet Earring Jewelry 1Sets | |
0 Bid | US $4.99 | 1h 52m |
 |
Mens Womens Titanium Sterling Silver Round CZ Antique 3 Pcs Wedding Rings Set | |
0 Bid | US $58.73 | 1h 56m |
 |
AMBER STERLING SILVER STUD EARRINGS SMALL BEAUTIFUL COLOR BEZEL SET ROUND SETTIN | |
0 Bid | US $12.99 | 2h 2m |
 |
BEAR CLAW PENDANT OR CHARM SET IN STERLING SILVER WITH ROUND TURQUOISE STONE | |
0 Bid | US $8.99 | 2h 3m |
 |
2 CARAT CZ WEDDING ENGAGEMENT RING SET SIZE 5678910 ROUND | |
3 Bids | US $24.99 | 2h 19m |
 |
Stacker Ring w Round Cut Black CZ in a Channel Setting Size 8 MF116 | |
0 Bid | US $24.00 | 2h 24m |
 |
3 CARAT WEDDING ENGAGEMENT RING SET SIZE 5678910 ROUND | |
0 Bid | US $24.99 | 2h 26m |
 |
Stacker Ring w Round Cut Amethyst CZ in a Channel Setting Size10 MF113 | |
0 Bid | US $24.00 | 2h 29m |
 |
25 CARAT WEDDING ENGAGEMENT RING SET SIZE 5678910 ROUND CZ | |
1 Bid | US $24.99 | 2h 33m |
 |
925silver charm round necklace bracelet earrings set | |
1 Bid | US $1.56 | 2h 38m |
 |
New Blue Pearl Round Loose Beads Necklace Earrings SET M219 | |
0 Bid | US $4.99 | 2h 38m |
 |
STR287 SIMULATED DIAMOND ENGAGEMENT STONES ALL ROUND WEDDING BAND SET | |
0 Bid | US $23.54 | 2h 40m |
 |
3 CARAT CZ WEDDING ENGAGEMENT RING SET SIZE 5678910 ROUND | |
0 Bid | US $24.99 | 2h 40m |
 |
14k Gold Bonded Stacker Ring Round Cut Clear CZ in a Channel Set Size 7 MF123 | |
0 Bid | US $24.00 | 2h 40m |
 |
New nice 925silver Round case sets necklace bracelet Gift Box FS058 | |
0 Bid | US $7.88 | 2h 48m |
 |
H769x Lots 4 sets Mixed Nice Wedding Gemstone CZ Jewelry Round Necklace Earrings | |
0 Bid | US $.99 | 2h 53m |
 |
14k Gold Bonded Stacker Ring Round Cut Clear CZ in a Channel Set Size 8 MF122 | |
0 Bid | US $24.00 | 2h 56m |
 |
135 ct NATURAL MINED GEM STONE SET LOT ROUND DIAMOND CUT for 2mm RED SAPPHIRE | |
0 Bid | US $14.99 | 2h 57m |
 |
Set Lot 100 CT NATURAL GEMSTONE ROUND Diamond Cut BLUISH PURPLE TANZANITE | |
0 Bid | US $9.99 | 2h 58m |
 |
8pcs Wholesale Clear Glass Cabochon Flat Round Findings F Settings 14x14mm GC002 | |
1 Bid | US $.99 | 2h 58m |
 |
307ct NATURAL EARTH GEM STONE SET LOT ROUND DIAMOND CUT BLUISH PURPLE TANZANITE | |
0 Bid | US $17.99 | 3h 3m |
 |
100 ct TOP QUALITY NATURAL GEM STONE SET ROUND CUT CORN FLOWER BLUE SAPPHIRE | |
0 Bid | US $9.99 | 3h 4m |
 |
300 ct SPLENDID NATURAL GEM STONE SET LOT ROUND DIAMOND CUT YELLOW SAPPHIRE | |
0 Bid | US $19.99 | 3h 8m |
 |
Stacker Ring w Round Cut Ruby CZ in a Channel Setting Size9 MF114 | |
0 Bid | US $24.00 | 3h 11m |
 |
305 ct NATURAL GEMSTONE SET LOT ROUND CUT for 3mm TOP BLUISH PURPLE TANZANITE | |
0 Bid | US $17.99 | 3h 13m |
 |
Set Lot 130 CT TOP QUALITY NATURAL GEMSTONE Round Cut Rich Red SAPPHIRE | |
0 Bid | US $24.99 | 3h 15m |
 |
Natural Gemstone 500 Ct Round Cut 4mm Set Lot Top Quality Swiss Blue Topaz | |
0 Bid | US $14.99 | 3h 17m |
 |
1 CTW ROUND AQUAMARINE BASKET SET STUD EARRINGS STERLING SILVER FREE SHIP | |
0 Bid | US $19.95 | 3h 19m |
 |
66 CTW ROUND AQUAMARINE BASKET SET STUD EARRINGS STERLING SILVER FREE SHIP | |
0 Bid | US $12.00 | 3h 19m |
 |
66 CTW ROUND BASKET SET AMETHYST STUD EARRINGS 925 STERLING SILVER GIFT BOX | |
0 Bid | US $12.00 | 3h 19m |
 |
66 CTW ROUND BASKET SET EMERALD STUD EARRINGS 925 STERLING SILVER GIFT BOX | |
0 Bid | US $12.00 | 3h 19m |
