sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 884
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I wrote function ROUND(B1,2) but I am not getting 0 at the end as I need .20 but getting 0.2 only
Thanks.
Sanjeev
I wrote function ROUND(B1,2) but I am not getting 0 at the end as I need .20 but getting 0.2 only
HP_China.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Has the best value considering its specs (video card, CPU, RAM, etc.) | 20% | Has the best value considering its specs (video card, CPU, RAM, etc.)0.2 | ||||
2 | Is best for gaming | 20% | Is best for gaming0.2 | ||||
3 | Is a brand that represents my values | 20% | Is a brand that represents my values0.2 | ||||
4 | Brings the most exciting features | 20% | Brings the most exciting features0.2 | ||||
5 | Is a brand I can trust | 19% | Is a brand I can trust0.19 | ||||
6 | Offers products I am proud to be seen with | 19% | Offers products I am proud to be seen with0.19 | ||||
7 | Is associated with eSports | 19% | Is associated with eSports0.19 | ||||
8 | Offers products with designs that appeal to me | 18% | Offers products with designs that appeal to me0.18 | ||||
9 | Is designed by gamers | 18% | Is designed by gamers0.18 | ||||
10 | Is recommended by gamers | 18% | Is recommended by gamers0.18 | ||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1:D10 | D1 | =A1&ROUND(B1,2) |
Thanks.
Sanjeev