Forum

Notifications
Clear all

Required formula

3 Posts
3 Users
0 Reactions
114 Views
(@kiranslncoffee-com)
Posts: 1
New Member
Topic starter
 

Dear Sir /Madam, Good day,

 

Find herein enclosed Excel sheet for getting payments (Column L ) Draw back amount 1%  

from bank based on column E (scroll date).

Bank will transfer total amount sometime which we don’t know payment belongs to which Scroll date (column E).

Example: Bank transferred  INR. 33877.00 – towards  Cell number L130+L133 +L134 +L135 having different Scroll date.

How to find this Amount  INR . 33877.00  belongs to which scroll date using formula.  

Awaiting your reply.

Thanks & Best Regards

Kiran.

 
Posted : 28/09/2023 2:17 am
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

No Excel sheet was attached. Please try again. This time, press 'Start upload' before you submit your reply. 

 
Posted : 28/09/2023 2:12 pm
(@keebellah)
Posts: 373
Reputable Member
 

I also suggest you state the Excel version you're using

 
Posted : 29/09/2023 2:06 am
Share: