Hi, I have a column of data containing the values, "Paid in Full" "Unpaid" and "Underpaid", I am looking for a formula that will place 0% in the next column if the data is either paid in full or underpaid, and 6% if the data is unpaid.This value is to be added as an extra charge for non payment.
Thanks
Charlie
Thanks
Charlie