| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a cell in excel will not display the formula total
my formula is P190 = sum(P129+P189)...P129 and P189 have money entries. P190
just keeps displaying a $ sign but no number totals. What am I doing wront? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a cell in excel will not display the formula total
John,
= sum(P129,P189) will work you don't need the plus but equally that won't cause your problem either. Do you have formatting on the cell? if so delete it and try again. A Custom format of $ would give the symptoms you describe. Mike "John" wrote: my formula is P190 = sum(P129+P189)...P129 and P189 have money entries. P190 just keeps displaying a $ sign but no number totals. What am I doing wront? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a cell in excel will not display the formula total
On Jun 14, 2:35 pm, Mike H wrote:
John, = sum(P129,P189) will work you don't need the plus but equally that won't cause your problem either. Do you have formatting on the cell? if so delete it and try again. A Custom format of $ would give the symptoms you describe. Mike "John" wrote: my formula is P190 = sum(P129+P189)...P129 and P189 have money entries. P190 just keeps displaying a $ sign but no number totals. What am I doing wront? Or if P129 and P189 are Text instead of Values. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ExcelExcel 2002 display formula in another cell as text | Excel Worksheet Functions | |||
| display revised total in Office 2003 when cell data changes | Excel Discussion (Misc queries) | |||
| Display total in more than one cell... | Excel Worksheet Functions | |||
| Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
| How do i get excel to add a range of times & display as total as . | Excel Discussion (Misc queries) | |||
Linear Mode
