Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
AB AB is offline
external usenet poster
 
Posts: 33
Default What happens if you put "+" before a formula?

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

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,345
Default What happens if you put "+" before a formula?

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


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


"AB" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
conditional formula to show "open" or "closed" SBS Excel Worksheet Functions 6 January 28th 06 01:48 AM
Insert "-" in text "1234567890" to have a output like this"123-456-7890" Alwyn Excel Discussion (Misc queries) 3 October 25th 05 11:36 PM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"