Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel/ powerpoint2003
well i dowload powerpoint and excel but when i go to it it wont open up all
it does is open up a box that has file named---------- file of type but when i put in a file named it says it the wrong file named.. so i dont know how to open it up ... thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel/ powerpoint2003
None of this makes much sense.
How did you "download" powerpoint and excel? From where? Do you have a CD with Microsoft Office for installing on your computer? Post back with more details and more clarity. Gord Dibben MS Excel MVP On Fri, 28 Apr 2006 16:51:01 -0700, princessdoll1971 wrote: well i dowload powerpoint and excel but when i go to it it wont open up all it does is open up a box that has file named---------- file of type but when i put in a file named it says it the wrong file named.. so i dont know how to open it up ... thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel/ powerpoint2003
Hi all, Okay i have 3 questions don't now the lot, story of my life.Anyway 1) What does the below mean =INDEX (C86:N68,REPORTPERIOD-1) 2) Was wondering is there a way i can produce the below Formula a smarter better way? =SUMIF('Major Projects'!$A$13:$A$24,'Fin. Perf. (Capex Resp)'!$B53,'Major Projects'!T$13:T$24)+SUMIF('Major Projects (2)'!$A$13:$A$27,'Fin. Perf. (Capex Resp)'!$B53,'Major Projects (2)'!T$13:T$27) 3) What does the + mean in front of = Eg: i have a formula that has =+ Would appreciate any help hope i explained it okay, have a great day. Cheers Will -- william4444 ------------------------------------------------------------------------ william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991 View this thread: http://www.excelforum.com/showthread...hreadid=537396 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel/ powerpoint2003
I'm assuming that there's a typo in the Index() formula.
The range is probably C86 to N86. Then, the formula is to choose one of the 12 cells in the range C86:N86, dependent on the value of "REPORTPERIOD" minus 1, and return the value in that cell. ReportPeriod can be a "named" cell, or even a "named" formula. Try: <Insert <Name <Define And see if there's anything with that name in the box. Click on the name and see what displays in the 'Refers To' box. As to the SumIf() formula: Since you are referencing 2 different size ranges on 2 different sheets, any changes would be cosmetic. As to the =+, It's a holdover from a ex-Lotus user, where formulas in Lotus start with a + sign, instead of a = sign in XL. It can be eliminated. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "william4444" wrote in message ... Hi all, Okay i have 3 questions don't now the lot, story of my life.Anyway 1) What does the below mean =INDEX (C86:N68,REPORTPERIOD-1) 2) Was wondering is there a way i can produce the below Formula a smarter better way? =SUMIF('Major Projects'!$A$13:$A$24,'Fin. Perf. (Capex Resp)'!$B53,'Major Projects'!T$13:T$24)+SUMIF('Major Projects (2)'!$A$13:$A$27,'Fin. Perf. (Capex Resp)'!$B53,'Major Projects (2)'!T$13:T$27) 3) What does the + mean in front of = Eg: i have a formula that has =+ Would appreciate any help hope i explained it okay, have a great day. Cheers Will -- william4444 ------------------------------------------------------------------------ william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991 View this thread: http://www.excelforum.com/showthread...hreadid=537396 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |