Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
I ham having below problem as I have formatted column B as Custom "dd" and when I multiply with numbers in column C it is not giving perfect result
My expected result is
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Custom Days | Number | B*C | ||
2 | 2/5/2021 | 05 | 2 | 03 | ||
3 | 2/6/2021 | 06 | 2.5 | 10 | ||
4 | 2/7/2021 | 07 | 3 | 04 | ||
5 | 2/8/2021 | 08 | 3.5 | 11 | ||
6 | 2/9/2021 | 09 | 4 | 06 | ||
7 | 2/10/2021 | 10 | 4.5 | 01 | ||
8 | 2/11/2021 | 11 | 5 | 08 | ||
9 | 2/12/2021 | 12 | 5.5 | 03 | ||
10 | 2/13/2021 | 13 | 6 | 09 | ||
11 | 2/14/2021 | 14 | 6.5 | 04 | ||
12 | 2/15/2021 | 15 | 7 | 11 | ||
13 | 2/16/2021 | 16 | 7.5 | 06 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B13 | B2 | =A2 |
D2:D13 | D2 | =B2*C2 |
C3:C13 | C3 | =C2+0.5 |
My expected result is
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Custom Days | Number | B*C | ||
2 | 2/5/2021 | 5 | 2 | 10 | ||
3 | 2/6/2021 | 6 | 2.5 | 15 | ||
4 | 2/7/2021 | 7 | 3 | 21 | ||
5 | 2/8/2021 | 8 | 3.5 | 28 | ||
6 | 2/9/2021 | 9 | 4 | 36 | ||
7 | 2/10/2021 | 10 | 4.5 | 45 | ||
8 | 2/11/2021 | 11 | 5 | 55 | ||
9 | 2/12/2021 | 12 | 5.5 | 66 | ||
10 | 2/13/2021 | 13 | 6 | 78 | ||
11 | 2/14/2021 | 14 | 6.5 | 91 | ||
12 | 2/15/2021 | 15 | 7 | 105 | ||
13 | 2/16/2021 | 16 | 7.5 | 120 | ||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:D13 | D2 | =B2*C2 |