Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Help with IF function

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Wellington
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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
    "Have a good time......all the time"
    Ian Mac

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thats great, it worked a treat.
    thanks
    Charlie

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,572
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    6 Thread(s)

    Default



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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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