Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using proper words in formulas (XP 2003)

    Good morning

    I have a cell on a workbook into which I must put either pp or cc (prepaid or charges collect) and I would like to use the result to determine the value of another cell, for example in cell B46 I have tried =IF(I22,'pp',F41), I have also tried =IF(I22,"pp",F41) & =IF(I22,pp,F41) and pointers greatfully received

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using proper words in formulas (XP 2003)

    The syntax of the IF function is =IF(condition, value-if-true, value-if-false).
    You must compare the value of I22 to "pp". For example:
    <code>
    =IF(I22="pp",F41,"")
    </code>
    This will return the value of F41 if I22 contains pp, and a blank otherwise.

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using proper words in formulas (XP 2003)

    Thanks Hans

    After 5 years I was closer than normal!!

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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