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?
Mmm...could be tricky......you 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
Jan 19, 2016 | Business & Productivity Software
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Feb 16, 2009 | Microsoft Excel for PC
Jan 21, 2009 | Microsoft Office Excel 2003 for PC
Jan 05, 2009 | Microsoft Business & Productivity Software
Jan 03, 2009 | Microsoft Business & Productivity Software
Nov 18, 2008 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Business & Productivity Software
Apr 23, 2008 | Microsoft Excel for PC
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.
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
79 people viewed this question
Usually answered in minutes!
×