Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using + in formulas - why?
Some individuals at my office use a + in front of cells when they are putting calculations within a cell. E.g. =+a1-b2 versus =a1+b2. First, why do they do this? Second, in a recent spreadsheet, I came across the formula =AVERAGE(+X:Y). The result of this formula gave me the average of only the first cell within the range (i.e. +X... the result of the cell was simply X). Second, why is this? Basically, what does the + do in the front of formulas and what benefit does it provide? I tried to search Excel help and even tried to find the answer in Google to now avail. Thanks in advance!! -- kylesin ------------------------------------------------------------------------ kylesin's Profile: http://www.excelforum.com/member.php...o&userid=18032 View this thread: http://www.excelforum.com/showthread...hreadid=483199 |
#2
|
|||
|
|||
Using + in formulas - why?
They take up space. I think it's a carryover from using Lotus 123 and
perhaps even from those files having been converted at some point. I have done find/replace and found =+ and replace with =. ************ Anne Troy www.OfficeArticles.com "kylesin" wrote in message ... Some individuals at my office use a + in front of cells when they are putting calculations within a cell. E.g. =+a1-b2 versus =a1+b2. First, why do they do this? Second, in a recent spreadsheet, I came across the formula =AVERAGE(+X:Y). The result of this formula gave me the average of only the first cell within the range (i.e. +X... the result of the cell was simply X). Second, why is this? Basically, what does the + do in the front of formulas and what benefit does it provide? I tried to search Excel help and even tried to find the answer in Google to now avail. Thanks in advance!! -- kylesin ------------------------------------------------------------------------ kylesin's Profile: http://www.excelforum.com/member.php...o&userid=18032 View this thread: http://www.excelforum.com/showthread...hreadid=483199 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |