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?
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
----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
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
Posted on Jan 02, 2017
Tips for a great answer:
Oct 24, 2015 | Office Equipment & Supplies
Apr 05, 2012 | Sharp EL-1197PIII Calculator
May 25, 2011 | Sharp EL-2630P Calculator
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.
Apr 30, 2011 | Computers & Internet
Jul 30, 2009 | Computers & Internet
Apr 11, 2009 | Microsoft Works 8.0 for PC
Feb 23, 2009 | Computers & Internet
Oct 08, 2008 | Microsoft Windows XP Home Edition
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!
Step 2: Please assign your manual to a product: