Question about Business & Productivity Software

1 Answer

Excel formula question

I have a total of pounds sold, and 4 ranges to pick from if it equals the criteris. i.e., If the pounds are below 1 #, it equals 0, if lbs are between 2 #'s it equals 40, if lbs are between 2 other #'s it equals 150, and if lbs are greater than the highest #, it equals 200.

I've tried IF statements, and can get the first condition to work, however, when I add another, it errors with #value.

What formula do I need use?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers
Re: Excel formula question

Mmm...could be could try the argument IF THEN ELSE in the functions list, in conjunction with additional columns to carry out the intermediate calculations, then you can hide those columns. perhaps you could also make use of conditional formatting. any problems come back to me.....could you place a snapshot of the sheet you are designing ? just highlight the cells , copy them, and use edit "paste special", tick values when pasting into this forum.

Posted on Jan 21, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

2 Answers

What is formula to find percentage of females in my workplace?

      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

    How to Calculate Percentages in Excel > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Business & Productivity Software

2 Answers

What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

2 Answers

Excel farmulas

Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif($A$1:$A$7000;F1;$D$1:$D$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Feb 16, 2009 | Microsoft Excel for PC

1 Answer


The formula in both versions is the same:


i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

How to do profit and loss a/c in ms excel

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Sales Product A

Sales Product B

Total Sales
Cost of Sales Product A

Cost of Sales Product B

Total Cost of Sales
Gross Profit




Office Supplies

Total Expenses

Net Profit

I hope this helps


Jan 05, 2009 | Microsoft Business & Productivity Software

1 Answer

How to add % (Percentage column ) in the excel

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Business & Productivity Software

1 Answer

Excel formulas

insert a row above row 1 and use data>filter>autofilter
view your database however you like

Nov 18, 2008 | Microsoft Excel for PC

1 Answer


Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1
Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Business & Productivity Software

1 Answer


Add an IF statement that encloses the formula you've already written. Assuming the result is in one cell, called CELLREF for purposes of writing this for you:
Thank you for rating FixYa!

Apr 23, 2008 | Microsoft Excel for PC

2 Answers

Budgets in excel

Dear Madiha35,


I would recommend the use of the Table Function in Excel.


Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.


Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.


Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.


Step 1:  Enter your data into the worksheet.


Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table


Step 3:  Verify Table range is correct, Click OK


Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.


Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above


Step 6:  Enter new data in row


Step 7:  Data is automatically calculated in formula.

Oct 22, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

79 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

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

Answer questions

Manuals & User Guides