The reason I had asked about putting the calculations and results into a BN file is because my Boss shows her calculations separate from her spread sheet. I guess so her customer can see actually how she came up with the new price shown. i'll keep the info, though in case it's needed.

I told her i could put both the calculations and answers in a BrailleNote file and then in the long run get the file printed. She still didn't give me one to do for her. In the end, this afternoon about half way through the day, she found her vender rep had already done a mark-up spread sheet for her. It happened to be for the amount she was supposed to mark the quotes up. Needless to say, she just deleted her numbers and put in his in her quote form. She still had a bit of Math to do for the installation price. She's got one left for tomorrow.

Kelly

----- Original Message ----- From: "Ann K. Parsons" <[EMAIL PROTECTED]>
To: "Braillenote List" <[email protected]>
Sent: Wednesday, July 06, 2005 6:45 AM
Subject: [Braillenote] calculator results


Hi Kelly,

Well, you could do it on the BN, but if you're going to put the result
into a spreadsheet, why not simply do it right there in the
spreadsheet?  Why aggravate yourself?

1.  Make note of the original price.

2.  Delete the info in the cell by pressing the delete key.

3.  type in the correct formula, e.g. =19.95*1.06

4.  Voila, you have the price, and you don't have to transfer from the
   BN or anything.

5.  Now if you *really* wanted to be spiffy, you could add a column to
your calculations and call it full price  or   total price.  Go to the
incert menu.

6.  Arrow down to collumns and press enter.

7.  Label your column as suggested above, you might want to use the
autofit option in the format menu to get the thing to fit correctly.

8.  Then put in your formula for your calculations, by using the cell
designation, e.g. =c3*1.06.

9.  Go down to the next cell and do the same formula, e.g. c4*1.06.

Now, don't take me wrong, folks, the BN is an excellent machine, but
sometimes "Less is better than More".   Sorry for taking up the list
with Excel trivia.  As I say, why aggravate yourself.  Let the
spreadsheet do the work.  That's what it's made for, old Kelly!

Ann P.

--
Ann K. Parsons
email:  [EMAIL PROTECTED]
WEB SITE:  http://home.eznet.net/~akp
"All that is gold does not glitter.
Not all those who wander are lost."  JRRT


___
To leave the BrailleNote list, send a blank message to
[EMAIL PROTECTED]
To view the list archives or change your preferences, visit
http://list.humanware.com/mailman/listinfo/braillenote



Reply via email to