View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Why put a plus sign after = sign in a formula

it does nothing. in Lotus, formulas were preceded with a + instead of =

when you begin a formula with +, XL automatically adds the = sign. most
likely to provide a smoother transition from Lotus to XL.


"kMan" wrote:

Very basic question guys and gals,

I have a formula like this in, say, Cell A2:
=+A1

What does the "+" sign do? I think I asked this question in a workshop ages
ago, but forgot the answer I got :(

Thanks for ya 'elp....