View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default "T" function broken?

On Tue, 14 Jul 2009 15:53:29 -0600, salgud wrote:

Thanks for the reply. Explains the behavior of the T function. Never heard
of a -Left function before. What other functions can you do that with
(besides RIGHT)?


It is not a -LEFT function. Rather it is a negation (minus sign) of the value
that the LEFT function returns. (As in =-"2").

It just happens that the arithmetic operators will operate on string
representations of numbers, and the result is a number.
--ron