Question about Microsoft Excel for PC

Say I have an amount of 3,750,000, I want the first column to calculate the amount up to 500,000, then the next column to calculate the amount from 500,001 to 2,000,000, then the next column to calculate the amount from 2,000,001 to 5,000,000. Can it be done?

Ad

Lets say you want Cell A1 is the number that you want to determin which column you want it to go in...try this formual you might need to tweek it or message back and tell me what you need
----First Column-----
=IF(AND(500,000>=$A1,$A1>=0),A1," ")

----Second Column-----
=IF(AND(2,000,000>=$A1,$A1>=500,001),A1," ")

-----Third Column----
=IF(AND(5,000,000>=$A1,$A1>=2,000,001),A1," ")

so this way it will only appear in the column that it fits in and you can replace A1 with the formula

Posted on Jul 10, 2009

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Know More

Oct 24, 2015 | Office Equipment & Supplies

See the instructions in the first column of the first page of the manual at http://files.sharpusa.com/Downloads/ForHome/HomeOffice/Calculators/Manuals/cal_man_EL1197PII.pdf

Apr 05, 2012 | Sharp EL-1197PIII Calculator

See the example in the fifth column of the second page of this manual: http://files.sharpusa.com/Downloads/ForHome/HomeOffice/Calculators/Manuals/cal_man_el2630P.pdf

May 25, 2011 | Sharp EL-2630P Calculator

Hide All

Percentages are calculated by using the following equation:

amount/total = percentage

Where percentage is in decimal format.

What do you want to do?

Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.

Example
The example may be easier to understand if you copy it to a blank
worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?

Example The example may be easier to understand if you copy it to a blank worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

download latest adobe and get open office free

Jul 30, 2009 | Computers & Internet

Use the following formula as an array formula, you need to hit "Shift+Ctrl+Enter" after entering the formula. Lets say you have the Name in column "B", the Age in column "C" and the amount paid in column "D". Here is the formula.

=SUM((B2:B7="Abhilash")*(C2:C7>0)*(D2:D7))

It will calculate the amount paid if the name =Abhilash" and the Agr is greater than zero.

=SUM((B2:B7="Abhilash")*(C2:C7>0)*(D2:D7))

It will calculate the amount paid if the name =Abhilash" and the Agr is greater than zero.

Apr 11, 2009 | Microsoft Works 8.0 for PC

From Joe-Bob's handy-dandy reference:

(wikiedia...)

Normal magic squares exist for all orders*n* ≥ 1 except *n* = 2, although the case *n* = 1 is trivial—it consists of a single cell containing the number 1

The constant sum in every row, column and diagonal is called the magic constant or magic sum,*M*. The magic constant of a normal magic square depends only on *n* and has the value

For normal magic squares of order*n* = 3, 4, 5, …, the magic constants are:

15, 34, 65, 111, 175, 260, …

(wikiedia...)

Normal magic squares exist for all orders

The constant sum in every row, column and diagonal is called the magic constant or magic sum,

For normal magic squares of order

15, 34, 65, 111, 175, 260, …

Feb 23, 2009 | Computers & Internet

1. enter = symbol

2. enter ( symbol

2. enter cell location where your cost value is

3. enter * symbol

4. enter 0.7

5. enter ) symbol

6. enter 0.175

eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

2. enter ( symbol

2. enter cell location where your cost value is

3. enter * symbol

4. enter 0.7

5. enter ) symbol

6. enter 0.175

eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Oct 08, 2008 | Microsoft Windows XP Home Edition

If I am doing price analysis and have List Prices but want to formulate the whole sheet that it will calculate 30% of prices to give me trade prices

How can I do this

How can I do this

Sep 02, 2008 | Microsoft Excel for PC

If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.

B5 columns are filled with this:

=IF(A5>$B$1,($B$2*$B$1)+((A5-$B$1)*($B$3)),A5*$B$2)

NOTE: The $ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a $ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Please rate as FixYa! or ask please clarify. ThankYa!

B5 columns are filled with this:

=IF(A5>$B$1,($B$2*$B$1)+((A5-$B$1)*($B$3)),A5*$B$2)

NOTE: The $ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a $ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Please rate as FixYa! or ask please clarify. ThankYa!

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

73 people viewed this question

Usually answered in minutes!

what do you mean by calculate the amount? what is the calculation? what are the components of the calculation?

×