Formula Question - starts "=+"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mr tom - 13 Feb 2007 13:51 GMT

Chaps,

Advanced User of Excel, but I've never seen this one before.

Formula could normally be =D18

I'm looking at somebody else's work and they've entered =+D18

The right answer is still shown.

What does =+ do? What are the differences to simply =?

Cheers,

Tom.

Reply to this Message

Don Guillett - 13 Feb 2007 14:00 GMT

They think that they are still using LOTUS. No difference but shouldn't be
used.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Chaps,
>
[quoted text clipped - 11 lines]
>
> Tom.

Reply to this Message

mr tom - 13 Feb 2007 14:09 GMT

Thank you. That's really helpful.

Cheers,

Tom.

> They think that they are still using LOTUS. No difference but shouldn't be
> used.
[quoted text clipped - 14 lines]
> >
> > Tom.

Reply to this Message

SharonT - 13 Feb 2007 16:59 GMT

A lot of accountants using the 10-keypad will start formulas with the + sign.
Excel automatically inserts the = sign ahead of the + sign.

Signature

Thanks, Sharon

> Chaps,
>
[quoted text clipped - 11 lines]
>
> Tom.

Reply to this Message