Hi Bart,
Sorry for taking so long to reply.
For case one, cell a1 would contain a left bracket, cell b1 is where a
number would be input, cell c1 would contain the plus sign, cell d1 is
where the user would enter another number, cell e1 would have the right
bracket, cell f1 the multiplication sign and cell g1 would be where the
user enters the third number. It would look like this before data entry:
ABCDEFGH
1 (_+_)*_=
2 0
and after data entry:
ABCDEFGH
1 (4+2)*6=
2 36
Cell a2 would have the formula:
=(B1+D1)*F1
This won't work if you want to do different operations on the numbers.
tc
Bart Aimar wrote:
Anthony Chilco ha scritto:
Hi Bart,
Hi Anthony,
Im sorry... but my english is very little... and it is possible I do not
correctly understand your suggest...
I have two suggestions then:
1) Have the user input the data in several cells with the operators
fixed in cells before, after and amongst them.
Can you help me and illustrate in other (symple :P) words?
2) If the operations differ from time to time so that 1) doesn't work,
write your own function to parse the input, for numbers and operators,
then do the calculation. This function can be entered just as a
standard function in A2.
Write a macro may be a solution... but - Ihope - only as last resource...
p.s. The function you'll have to write won't be simple, but it's not
rocket science.
Yes...:-) but I do not have experience in addon functions used directly
from a cell...
Some link for examples and/or spec documentation ?
Thank's in advanced
Bart
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
