| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
an extra "+" sign in formula
hi there,
when you have a formula that runs like that =+D13/100 ,then what does that 'plus' sign stand for? What is it for, actually? -- seeya! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
an extra "+" sign in formula
Means it was probably imported from Lotus. You can delete it.
-- Regards, Dave "chris" wrote: hi there, when you have a formula that runs like that =+D13/100 ,then what does that 'plus' sign stand for? What is it for, actually? -- seeya! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
an extra "+" sign in formula
It doesn't do anything.
Your formula is equivalent to: =d13/100 Lots of people came from Lotus where formulas started with + and they've combined it with excel's =. chris wrote: hi there, when you have a formula that runs like that =+D13/100 ,then what does that 'plus' sign stand for? What is it for, actually? -- seeya! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
an extra "+" sign in formula
I think it's a "carry over" from Lotus 123 but in Excel it's redundant!
"chris" wrote: hi there, when you have a formula that runs like that =+D13/100 ,then what does that 'plus' sign stand for? What is it for, actually? -- seeya! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get the equal sign on my formula bar in excel | Excel Worksheet Functions | |||
| Having to key the equal sign to start a formula | Excel Worksheet Functions | |||
| Formula for int. paid when extra monthly pmts are made. | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
