What happens if you put "+" before a formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AB - 26 May 2008 06:57 GMT

I'm unable to understand what use a "+" sign has if it is put before a formula.
For ex: +(C13*(1+$M$10)+J13)/(1-$M$12) gives the same result as
(C13*(1+$M$10)+J13)/(1-$M$12).

Reply to this Message

Sandy Mann - 26 May 2008 09:42 GMT

I assume you mean that +(C13*(1+$M$10)+J13)/(1-$M$12) give rhe same result
as =(C13*(1+$M$10)+J13)/(1-$M$12)

I believe that this was to make Excel compatable with Lotus which was the
eading spreadsheet program when XL came out.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> I'm unable to understand what use a "+" sign has if it is put before a
> formula.
> For ex: +(C13*(1+$M$10)+J13)/(1-$M$12) gives the same result as
> (C13*(1+$M$10)+J13)/(1-$M$12).

Reply to this Message