software

i am using a formula

in c1
if(a1=quot;aquot;,quot;***quot;,quot;quot;)

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

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

thanksHi,

Use

=if(trim(a1)=quot;aquot;,quot;***quot;,quot;quot;)

Regards

Govind.

wrote:

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

if(trim(a1)=quot;aquot;,quot;***quot;,quot;quot;). --Bruce

quot; wrote:

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

On Thu, 29 Dec 2005 21:19:49 -0500, wrote:

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

thanks againgt;Hi,

gt;Use

gt;=if(trim(a1)=quot;aquot;,quot;***quot;,quot;quot;)

gt;Regards

gt;Govind.

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