I have a spreadsheet that lists what payment terms have been agreed to (monthly, quarterly, biannual, annual, custom) and I want a column that takes the total of another column and then finds the payment terms and divides the number according to how many payments.
For example
Client A is paying quarterly, 5000, result should be 1250
Client B is paying annually, 5000, result 5000
Client C is paying monthly, 5000, result 416.67
Client D is paying biannually, 5000, result 2500
How do I get it to look at the text column (Col X) and then look at the number column (L) and return the right split?
Bookmarks