Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formulas and the relevance of this {
Help,
I have a frustrating problem in Excel. I'm making some changes to the formula below within an existing spreadsheet. {=SUM((Data_Account=$A5)*(Data_CloseDate<"open")* (Data_Type="Put")*(Data_RO<"Y")*Data_OverallProfi tLoss)} Now when I make any changes to the forumla, Excel removes the { and } from each end, then enters the result as 0. Yet when you click on the 'Edit formula' it shows the result within this popup window as the correct value (i.e. not 0) I tried adding the { } back into the forumla, but this just changes the text to a string. Any ideas ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formulas and the relevance of this {
Paul
that formula was "array entered". You need to press Ctrl-Shift-Enter rather than just Enter. Regards Trevor "Paul Hollands" wrote in message om... Help, I have a frustrating problem in Excel. I'm making some changes to the formula below within an existing spreadsheet. {=SUM((Data_Account=$A5)*(Data_CloseDate<"open")* (Data_Type="Put")*(Data_RO<"Y")*Data_OverallProfi tLoss)} Now when I make any changes to the forumla, Excel removes the { and } from each end, then enters the result as 0. Yet when you click on the 'Edit formula' it shows the result within this popup window as the correct value (i.e. not 0) I tried adding the { } back into the forumla, but this just changes the text to a string. Any ideas ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formulas and the relevance of this {
When you are finished editing the formula hit
Shift + Ctrl + Enter HTH "Paul Hollands" wrote: Help, I have a frustrating problem in Excel. I'm making some changes to the formula below within an existing spreadsheet. {=SUM((Data_Account=$A5)*(Data_CloseDate<"open")* (Data_Type="Put")*(Data_RO<"Y")*Data_OverallProfi tLoss)} Now when I make any changes to the forumla, Excel removes the { and } from each end, then enters the result as 0. Yet when you click on the 'Edit formula' it shows the result within this popup window as the correct value (i.e. not 0) I tried adding the { } back into the forumla, but this just changes the text to a string. Any ideas ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formulas and the relevance of this {
Thankyou both so much, you are both 100% correct.
Seems so simple now. Thanks again Paul |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formulas and the relevance of this {
You're welcome ... it's not something you come across every day. Lot's of
things are simple when you know how ... they can be very hard until you do. Regards wrote in message oups.com... Thankyou both so much, you are both 100% correct. Seems so simple now. Thanks again Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Excel recalculates formulas when opening files last saved by an earlier version of Excel | Excel Programming |