Question about Microsoft Excel for PC

2 Answers

Help How to add 15% to the existing value

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 4 Answers

In another column put in a formula (using the =) to multiply the current cell by 1.15. For example if your current values are in column A, then in the first cell in, say, column B put in the formula =A1*1.15, then copy this down the spreadsheet using the + in the bottom right hand corner of the cell border.
If you particularly want the final values back in the original column then highlight the new column (arrow at the top of the column), copy, highlight old column and select paste special - value.

Posted on Jul 22, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sergeant:

    An expert that hasĀ over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 214 Answers

Go to page setup and under scaling you can adjust to your required percentage

Posted on Jul 22, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

4 Answers

Identifying Cells which add up to a desired result


What do you want to add up to 18? once I understand exactly what your trying to do I will be able to assist you further.
Thanks,
Lee

Sep 09, 2008 | Microsoft Business & Productivity Software

1 Answer

Having troube with my FOREIGN KEYs on two tables.


I suggest you visit this website you will get the solution, I tried and it worked.

http://bit.ly/1bUVmuW

Nov 25, 2013 | Business & Productivity Software

1 Answer

How could i set up mi shop/crogery store with pc america ? the items


You add items on the INVENTORY MAINTENANCE screen or if you have an existing list or database, you can import it into PCAmerica's database. You may need professional help with this, but if you have a large inventory, it would be well worth the cost.

B Mattern
sysadmin@ccybernet.com
Please return and give me a favorable rating if this helps or is of value to you.
Feel free to email me with more details if need be.

Jul 08, 2011 | Pc America Restaurant Pro Express

2 Answers

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...


Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Question no. 2 For the 50 observation given below. Prepare Frequency Distribution for the the class interval is 10 (lower limit starting is 0) and upper limit is 80. Also plot in graphing. 64 62 52 50 70...


64 62 52 50 70 60 55 20 25 48 35 55 55 47 64 42 36 50 30 53 51 63 58 50 60 54 33 48 40 76 61 46 65 65 15 45 58 40 64 18 33 40 64 18 33 40 48 9 38 41

Highest value observed: 76
Lowest Value: 9
Standard deviation from the ungrouped data: 15.25
Frequency:
Mean: 46.94
Standard deviation from grouped data: 15.40

Oct 23, 2009 | Microsoft Excel for PC

1 Answer

Excel Addition


you may add typed-in values (numbers only) or numbers found in cells.
always start your equation with = then separate values with +

Nov 22, 2008 | Microsoft Business & Productivity Software

2 Answers

Excel


this is little beyond what I know, however, I can do count characters, but not numbers. do a search on the web, there are lots of method for counting characters, you can reverse the count.
I think you need is a program to do that.
you can find viusal basic, c++ user group on the web, they may be the best bet.

good luck

Nov 07, 2008 | Microsoft Excel for PC

1 Answer

Excell


=if(B2>0,B2+20,0)

in this case if the value of cell B2 is greater than 0, the value will be added to 20, if its less than zero it will return the answer 0.

Mar 13, 2008 | Business & Productivity Software

1 Answer

Using if and then to add values to a cell


Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:
=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

Dec 09, 2007 | Business & Productivity Software

Not finding what you are looking for?
Microsoft Excel for PC Logo

121 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...