Hi,
I want to calculate a percentage of any amount as I have two options i.e. Debit Card and Credit Card.
I want to put a formula which check that If Column A contains "Debit Card / Credit Card" then percentage should be as below,
In case of Debit Card = If amount is less than equal to 2000 then percentage should be 0.75% of a given amount. If amount is greater than 2000 than percentage should be 1% of a given amount.
In case of Credit Card = Percentage should be 1% of a given amount.
Please help me to update the formula to complete the task.
Thanks & regards,
Amit Chand
Bookmarks