Search results for query: *

Sorry, my bad, in the above, the UDF code for Excel VBA should have been a Function, not a Sub: Function SumIt(Arg1 As Variant, Arg2 As Variant) SumIt = Arg1 + Arg2 End Sub I don't know how to edit after it has been submitted, or I would have simply edited the above. Sorry for any...

Hi guys, I have three questions relating to user-defined functions using Lotus: (1) Does Lotus provide the ability to use LotusScript to produce a User Defined Function (UDF) as can be done in Excel? That is, can you produce a function that returns a value based on inputs to the function and...

Dale, That was absolutely beautiful. Thank you :), Mike

Hi Dale, I am absolulely grateful for your detailed responses. I am a programmer too; however at the moment I do not have Lotus in front of me (and have not used it since about 1993!) and need to have a proper evaluator written... My only question left, then, regards this quote: > "In 123...

Dale, I really appreciate that extremly clear description. :) One last question: so the formula: = 1 + 2 Would be evaluated to '3' in both Lotus and Excel? I am basing this on the assumption that the "=" sign would also qualify as " character used in a formula" as you put it? Thanks...

Thank's CrazyBird, I really appreciate it... Just to clarify, what if I did put 1 + 2 in a cell? Would it be intepreted as text and not as an equation evaluating to 3? And based on what you wrote above, would writing (1 + 2) in a cell evaluate to 3? Thanks again, and I'm sorry for such...

Forgive me as I've not used Lotus in a long time, and I do not have it in front of me currently... If one enters a formula into Lotus, say: 1 + 2 Or @SUM(A1:C3) Does the system automatically add a leading "=" sign, or Lotus operates without the "=" sign? Also is it legal to even...