S Sarfraz Khan Member Sep 5, 2015 #1 Dear Sir, I have four column Ledger Amt, Dr Ledger Amt, Cr Statement, Amt Difference. I want to get difference between Ledger amt and statement amount as per attached sheet "Expected Result" Column. Attachments Bank Recon Help File.xlsx 8.5 KB · Views: 8
Dear Sir, I have four column Ledger Amt, Dr Ledger Amt, Cr Statement, Amt Difference. I want to get difference between Ledger amt and statement amount as per attached sheet "Expected Result" Column.
Khalid NGO Excel Ninja Sep 8, 2015 #2 Hi Sarfraz, Can you explain what is the logic of your expected results? Regards,
Chihiro Excel Ninja Sep 8, 2015 #3 Is there error in H6 Expected result? It does not seem to follow logic of all other rows. All other rows are simple addition and subtraction. =D4+E4-F4
Is there error in H6 Expected result? It does not seem to follow logic of all other rows. All other rows are simple addition and subtraction. =D4+E4-F4