Question about Palo Alto Business Plan Pro 11 Full Version for PC (8002338)

1 Answer

Im having trouble with the spreadsheet adding up the total of the numbers it comes up with " Value#" all the time and this can not be changed.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Expert
  • 36 Answers

It just means that the column is not big enough to fit the full number in. Just widen your column and it should dissapear

Posted on Mar 23, 2011

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have a column containing a value of a single letter. I need the spreadsheet to sort add rows by letter.


Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

Sep 07, 2014 | Microsoft Excel for PC

Tip

Copy PDF tables to excel?


"I have a national statistics book in PDF, it has a number of tables I want to work with in excel. So I paste all the colums and copy in Excel. However, the format is wrong, all colums in a single excel colum. How can i deal with it, any suggestion?"<br /><br />Are you also be troubled with the problem? Here share you an easy solution to solve it.<br /><br />The PDF to Excel Converter can convert PDF to Excel, convert PDF eBooks to Excel on Mac with more accurate-looking and highly-editable XLS files. There will be no need to reformat the converted Spreadsheets. PDF to Excel Converter for Mac makes it a clinch to re-use tables and spreadsheets from PDF files in Microsoft Excel.<br /><br />Get a <a href="http://www.doremisoft.com/pdf/pdf-to-excel-xls-converter-mac.html"><span style="font-weight: bold;">PDF to Excel Converter for Mac </span></a>users or <a href="http://www.doremisoft.com/pdf/pdf-to-excel-converter.html"><span style="font-weight: bold;">PDF to Excel Converter</span></a> on Windows OS<br /><br />Free download it and get a free try!<br />

on Nov 23, 2010 | Computers & Internet

1 Answer

Sum numbers in a column down until you come to a blank, then start again


Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

1 Answer

To change the Date and Time on my Sharp EL-1801PIII Calculator your instructions refer to a faceplate, which I do not have. What keys are associated with "Time Set," "AM/PM,"...


GRAND TOTAL / RATE SETTING MODE SELECTOR:
"GT": Grand Total
"•": Neutral
"RATE SET": To set the date, time, and tax rate, set this switch at the "RATE SET" position.
Date:
• Enter in the order of month, day and year, then press to complete the entry.
• Use to separate month, day, and year.
• When is pressed, the number entered is evaluated and displayed as "date" if the
value is within the following range; "Error" is displayed otherwise, and the previously set
date is restored.
Month: 1 - 12; day: 1 - 31; Year: 2000 - 2099 (in 4 digits) or 00 - 99 (in 2 digits)
Time:
• Enter in the order of hour, minutes, then press to complete the entry.
(There is no entry available for the seconds value. The clock starts at zero second.)
• If the hour/minute digit is less than 10, it is not necessary to enter the first digit "0".
• Use to separate hour and minute values.
• When is pressed, the number entered is evaluated and displayed as "time" if the
value is within the following range; "Error" is displayed otherwise, and the previously set
time is restored.
Hour: 0 - 23 (24-hour system for the hour entry), Minute: 0 - 59

Dec 16, 2010 | Sharp Office Equipment & Supplies

1 Answer

I built a spreadsheet that uses a lot of DSUM equations to analyze a database of transaction information. I'm noticing that it is taking a very long time for the spreadsheet to calculate, even after...


The DSUM function is very useful, but it does use a lot of processing. Every DSUM function does a scan of every row of your table. There are a few ways you can reduce computing time.
First (and the most obvious) is to reduce the number of DSUM functions or reduce the size of your table. I presume you have already tried this.
Secondly consider using Pivot Tables to do the task, or to reduce the size of your table. There is a Pivot Table wizard under the Data menu. It's a fairly user friendly feature of Excel, so I suggest you try it out on your table. Pivot tables will be many times faster than DSUM functions because they only scan the table once. There are some tutorials available on the internet.
Third, if your DSUM functions are only summing one value in the table, then it would be much quicker if you can sort the table on the lookup value (or criteria). Then use LOOKUP, VLOOKUP or MATCH functions to find the value you're looking for. On a sorted table, these functions are many times faster that DSUM functions.
I hope this helps a little. It's hard to diagnose without seeing the spreadsheet and knowing the details of the problem you are trying to solve.

Oct 23, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Present value of a loan


The present value of any future monthly (?) stream of payments stretching some 24 years into the future takes into account the time value of money and depends on the interest rate assumed to apply for each month throughout those 24 years.

There are formulae to calc this for an equal monthly payment and a constant interest rate, over the term but for a variable interest rate you need a spreadsheet.

In the simple case of zero interest assumed throughout the term, present value = current principal balance, but for any positive interest rate, the total present value of the future payment stream is less than the current principal balance.

Oct 06, 2008 | Texas Instruments TI-30XA Calculator

1 Answer

Attendance


You might be able to find what you want here:
http://www.usd.edu/trio/tut/excel/

Aug 09, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Palo Alto Business Plan Pro 11 Full Version for PC (8002338) Logo

Related Topics:

95 people viewed this question

Ask a Question

Usually answered in minutes!

Top Palo Alto Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Palo Alto Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...