Dsunil05
New Member
- Joined
- Feb 20, 2015
- Messages
- 34
- Office Version
- 2021
- 2019
- 2013
- 2007
- 2003 or older
- Platform
- Windows
SAVING A/C | COMISSION AMOUNT | FD A/C | COMISSION AMOUNT | |
10 | 0 | 10 | 0 | |
25 | 400 | 25 | 400 | |
35 | 0 | 35 | 0 | |
50 | 400 | 50 | 900 | |
65 | 0 | 65 | 0 | |
70 | 0 | 70 | 0 | |
75 | 400 | 75 | 1500 |
<tbody>
</tbody>
THIS SALE COMMISSION TABLE OF BANK
1.) IN FIRST TABLE HOW COMMISSION REFLECT SAME IN "COMMISSION AMOUNT COLUMN" WHEN A/C COMES IN MULTIPLE OF 25 ( OR ANY OTHER MULTIPLE OF NUMBER)
I TRIED THIS FOR "B" COLUMN = IF (A3/25>=1,400,0)
BUT B4 TO B8 SHOWING 400
2.)IN SECOND TABLE HOW COMMISSION REFLECT DIFFERENT IN "COMMISSION AMOUNT COLUMN" WHEN A/C COMES IN MULTIPLE OF 25 ( OR ANY NUMBER)
IN SECOND TABLE EVERY TIME CHANGE COMMISSION AMOUNT WHEN FD A/C COMES IN MULTIPLE OF 25 ( OR ANY OTHER MULTIPLE OF NUMBER)
WHAT TO DO?
GUIDE ME WITHOUT USING VBA / MACRO I AM USING MS EXCEL 2007
Last edited: