Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Add an IF stmt to existing formula (excel xp)

    I have this formula to look for an up or down arrow and change it to an S. But now i also need to add that if there is a hyphen in the cell i need to make the cell blank. Could someone please help me add to this formula. Thank you very much.

    =IF(ISERROR(FIND("

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Add an IF stmt to existing formula (excel xp)

    Hi,
    Make the statement:
    IF(ISERROR(FIND("-",$AD$759)),IF(ISERROR(FIND("
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add an IF stmt to existing formula (excel xp)

    ok, now i'm getting the hang of it. thanks

Posting Permissions

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