Function in a Teemplate

[Boris Mohar]

Hello,

I would like top implement a Function =(B*20) in column C of my template.
It does not get saved. Is it possible to implement a function in a template?

Regards,

Boris Mohar

 

[Frank Kabel]

Hi
where did you store your function and what is the exact code?

 

[Bob Phillips]

Boris,

That should work okay.

Did you put =B1*20 in C1? =B*20 doesn't make sense as it will treat B as a
range name and try to get it's value.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Boris Mohar]

Boris,

That should work okay.

Did you put =B1*20 in C1? =B*20 doesn't make sense as it will treat B as a
range name and try to get it's value.

Yes, and it works when test it manually by entering data in any B column B.
The C column gets B values and multiplies them by 20. When I save the xlt
file and open it, I import the data the column C, it contains neither the
data nor the formula. Even when I open the saved template I do not see the
formula any more. I must admit that I am rather new at this and that the
error is probably mine. Perhaps it would help to describe what I am trying
to accomplish. I created a template into which I import a BOM for a circuit
board. Column B contains a number of (identical) parts and column C should
come up how many parts I need to by based on how many boards are being made
(20)


Regards,

Boris Mohar

Viatrack Printed Circuit Designs

 

[Bob Phillips]

It sounds like the import is overwriting column C. What steps do you go
through to import it?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Boris Mohar]

It sounds like the import is overwriting column C. What steps do you go
through to import it?

Data> Import External Data
My data is the tab delimited BOM text. I set it up so that there is a blank
entry for column C

The only imports available are Edit Text import and Data range properties.
Others are grayed out.

I select Edit Text Import and go with the defaults. At this point data gets
imported and the column C gets overwritten with a blank. Prior to import
Column C contained all zeroes As it should because column B contained no
data.

I feel like I am really close to solving this. Someone just has to smack me
on the back of my head

Regards,

Boris Mohar

Got Knock? - see:
Viatrack Printed Circuit Designs http://www3.sympatico.ca/borism/

void _-void-_ in the obvious place

 

[Boris Mohar]

Hi
where did you store your function and what is the exact code?

Frank,

See if my answers to Bob make any sense. Sorry to be such a noob.
I am willing to try anything at this point.