Outline ·
[ Standard ] ·
Linear+
Credit Cards Maybankard 2 Gold & Platinum Cards V9, Pls read post 1-3 & use Search Topic 1st
|
holybo
|
Apr 1 2014, 05:25 PM
|
|
QUOTE(fruitie @ Apr 1 2014, 12:56 AM) I think those hotels I booked were just normal hotels not like Shangri-La.  I booked one hotel in Pattaya, one in Bangkok and three in Chiang Mai.  Is the 7% discount promotion is still available? when is the dateline?
|
|
|
|
|
|
holybo
|
Jun 4 2014, 09:47 PM
|
|
May I know how they calculate the cashback ya? I spent RM1000.06 but my cashback is RM49.97.
|
|
|
|
|
|
holybo
|
Jun 5 2014, 09:21 AM
|
|
QUOTE(hiansitt @ Jun 4 2014, 09:56 PM) holybocalculate by round down every transaction to sen | Transacted Amount | rebate | | RM1 | RM0.05 | | RM1.01 | RM0.05 | | RM1.19 | RM0.05 | | RM1.20 | RM0.06 |
I see, is it rounding down to every 20 cents? Using which function in excel?
|
|
|
|
|
|
holybo
|
Jun 5 2014, 06:15 PM
|
|
QUOTE(cybpsych @ Jun 5 2014, 09:46 AM) =ROUNDDOWN(A1*5%,2)where A1 is the transaction value refer here and here  thanks bro!!
|
|
|
|
|