The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 4 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
hello
i have a mathematical problem... which i want an excel solution
i have  banks lending and borrowing ...
for example bank A borrows from bank B
           bank B lends money to bank A
so i want to check that bankA reported that he borrowed from bank B
                     and bank B reported that he gave money to bank A
so my question how to do this by excel ....i need an equation pleaseÂ
Â
datelendingborrowing periodamountrateweight5/24/2016NB1 WK2.0000.438%0.1093755/24/2016COB1 WK3.0000.500%0.15/24/2016GB1 WK5.0000.500%0.15/24/2016MBO/N4.0000.250%0.015/24/2016DBO/N7.0000.250%0.01755/24/2016NBPO/N4.0000.250%0.02255/24/2016MNBO/N1.0000.375%0.003755/24/2016NHO/N4.0000.250%0.015/24/2016BKHO/N1.0000.250%0.03755/24/2016GiO/N2.0000.438%0.008755/24/2016BKiO/N2.0000.375%0.00755/24/2016MiO/N2.0000.313%0.006255/24/2016NiO/N2.0000.250%0.0055/24/2016NiO/N1.5000.250%0.003755/24/2016COB1 WK2.0000.500%0.15/24/2016NB1 WK2.0000.438%0.1093755/24/2016BKHO/N1.0000.250%0.03755/24/2016GiO/N2.0000.438%0.00875
Attachments:
-----------