Thanks:  0
Likes:  0

# Thread: Help with IF function

1. 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

2. Hi,

Assuming the data column contains "Paid in Full", and so on, is you column A, then formula is inserted in column B:

=if(or(a1="Paid in Full",a1="Underpaid"),0%,if(a1="Unpaid",6%,"N/A"))

HTH

3. On 2002-03-27 15:09, Charlie wrote:
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
Assuming your list is in A1 down, use:

=IF(OR(A1={"Paid in Full","Underpaid"}),0%,6%)

change the format to Percentage

4. Thats great, it worked a treat.
thanks
Charlie

5. =(A1={"Paid in Full","Underpaid"})*0%+(A1="Unpaid")*6%

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•