+ Reply to Thread
Results 1 to 4 of 4

trim function-how would one incorporate the trim function within the if statement?

  1. #1
    specter@doom.com
    Guest

    trim function-how would one incorporate the trim function within the if statement?

    i am using a formula

    in c1
    if(a1="a","***","")

    sometimes the formula fails in subsequent rows
    i suspect that there is a blank space following the "a"

    how would one incorporate the trim function within the if statement
    or do you have to use a helper column to trim and then evaluate the
    trimmed result

    thanks


  2. #2
    Govind
    Guest

    re: trim function-how would one incorporate the trim function within the if statement?

    Hi,

    Use

    =if(trim(a1)="a","***","")

    Regards

    Govind.


    specter@doom.com wrote:

    > i am using a formula
    >
    > in c1
    > if(a1="a","***","")
    >
    > sometimes the formula fails in subsequent rows
    > i suspect that there is a blank space following the "a"
    >
    > how would one incorporate the trim function within the if statement
    > or do you have to use a helper column to trim and then evaluate the
    > trimmed result
    >
    > thanks
    >


  3. #3
    bpeltzer
    Guest

    re: trim function-how would one incorporate the trim function within the if statement?

    if(trim(a1)="a","***",""). --Bruce

    "specter@doom.com" wrote:

    > i am using a formula
    >
    > in c1
    > if(a1="a","***","")
    >
    > sometimes the formula fails in subsequent rows
    > i suspect that there is a blank space following the "a"
    >
    > how would one incorporate the trim function within the if statement
    > or do you have to use a helper column to trim and then evaluate the
    > trimmed result
    >
    > thanks
    >
    >


  4. #4
    specter@doom.com
    Guest

    re: trim function-how would one incorporate the trim function within the if statement?

    On Thu, 29 Dec 2005 21:19:49 -0500, specter@doom.com wrote:

    thank you
    just couldn't get it through my hard head that it was easier than i
    was making it

    thanks again


    >Hi,


    >Use


    >=if(trim(a1)="a","***","")


    >Regards


    >Govind.


    >i am using a formula
    >
    >in c1
    >if(a1="a","***","")
    >
    >sometimes the formula fails in subsequent rows
    >i suspect that there is a blank space following the "a"
    >
    >how would one incorporate the trim function within the if statement
    >or do you have to use a helper column to trim and then evaluate the
    >trimmed result
    >
    >thanks


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1