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

A

AB

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).
 
S

Sandy Mann

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.
--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top