RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Guys, Wishing all of you a very Happy Happy New Year 2021.
I have 2 workings in this sheet. One is a accounting format sheet where I want the right formula and the other is a general sheet where the formula works. I am not able to get the right answer in the accounting format when I have applied the same formula in both the workings. Does the formula work in a general format sheet only, if not, please share me the solution for the above.
I have 2 workings in this sheet. One is a accounting format sheet where I want the right formula and the other is a general sheet where the formula works. I am not able to get the right answer in the accounting format when I have applied the same formula in both the workings. Does the formula work in a general format sheet only, if not, please share me the solution for the above.
Calculated Duties and taxes.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Accounting Format | General Format | ||||||||
2 | 304.87 | 1 | ||||||||
3 | 29,211.67 | 2 | ||||||||
4 | 32,817.08 | 3 | -3 | |||||||
5 | 450.00 | 4 | -2 | |||||||
6 | 304.87 | -4 | ||||||||
7 | 29,211.67 | -1 | ||||||||
8 | 32,817.08 | 4 | 6 | -10 | ||||||
9 | 59.54 | -245.33 | 10 | Matched | =IF(G9+H8=0,"Matched","Not Matched") | |||||
10 | 4,111.34 | -25,100.33 | ||||||||
11 | 10,145.81 | -22,671.27 | ||||||||
12 | 24,428.01 | 24,428.01 | ||||||||
13 | 30,030.10 | 29,580.10 | ||||||||
14 | 436.48 | 436.48 | ||||||||
15 | 59.54 | -245.33 | ||||||||
16 | 4,111.34 | -25,100.33 | ||||||||
17 | 10,145.81 | -22,671.27 | ||||||||
18 | 83,527.97 | 1,25,117.24 | -41,589.27 | |||||||
19 | 41,589.27 | Not Matched | =IF(C19+D18=0,"Matched","Not Matched") | |||||||
duties & TAxes (2) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G4 | G4 | =-E4 |
G5 | G5 | =-F3 |
G6 | G6 | =-F5 |
G7 | G7 | =-E2 |
E8:G8 | E8 | =SUM(E2:E7) |
F9 | F9 | =F8+E8 |
G9,C19 | G9 | =IF(F9+G8=0,"Matched","Not Matched") |
C9:C11 | C9 | =A9-B2 |
C12,C14 | C12 | =A12 |
C13 | C13 | =A13-B5 |
C15:C17 | C15 | =A15-B6 |
A18:C18 | A18 | =SUM(A2:A17) |
B19 | B19 | =B18-A18 |