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?
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
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.
96 views
Usually answered in minutes!
what do you mean by calculate the amount? what is the calculation? what are the components of the calculation?
×