# Excel 2002 formula

I am constructing a Sales Order form and I'm having trouble with a formula. In column E the user will enter a value. From that value I need to create the pricing based on a value in column B. If the value in E is less than or equal to 37, then multiply the value in B by 14.3, If E is greater than 37 but less than or equal to 43, then multiply the value in B by 15.05, and, if E is greater than 43 but less than or equal to 49, then multiply the value in B by 15.8. If greater than 49 then return no value.

Posted by on

• narco Dec 05, 2007

Thank you for your help. It worked and I was able to complete the Order Form... :-)

• SonuC May 11, 2010

Can i freeze a column and a row simultaneously in a Excel Sheet

×

Give me all excel formulas

Posted on Feb 18, 2008

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Posted on Dec 04, 2007

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

×

my-video-file.mp4

×

## Related Questions:

### How do you subtract on Excel

EXCEL view the operation as a function fX and you enter it like this: =MINUS(H21,H22) This will show up in the cell and on the function bar above the column letters. The cell number would have a value in it. In this example H21 would have the value 10,and H22 would have the value 5. The formula would reside say in H23 and would show the result of the operation as 5.
10
5
5 (Formula in cell is as shown above)

Sep 19, 2017 | Excel Computers & Internet

### How do i subtract two cells and progress down a row by a day so the next day the formula subtracts the current day and previous day?

You have to start the sequence with a slightly different formula because there is no preceding value for Monday.
The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.
Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

Mar 06, 2015 | Microsoft Excel 2010

### Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

### Count how many times a value appears in a column, based on anothe

Go to the cell you want this total in.
Type this formula:
=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))
make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Dec 21, 2008 | Microsoft Excel for PC

### Excel will not displaying the results of a trend array formula

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

### Copying data from one sheet to another if two fileds match

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
=INDEX(\$C\$2:\$C\$5,MATCH(D2,IF(\$B\$2:\$B\$5=E2,\$A\$2:\$A\$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

### In Excel adding positive and negative numbers

Yes,

1. Select the column. (click on top of the column it will select)
2. Right Click and select Format Cells.
3. Select Currency in Category then press OK
Now just type your Numbers i.e. 571 for \$571 and -650 for -\$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

### Excel

I THINK what he is trying to say

you do not want the cell on the sales form to show an error message, instead not to show anything. It has been awhile for excel but i believe if you right click the cell and goto properties you can change what it should show.

Nov 13, 2007 | Computers & Internet

### I have data in excel

Excel cannot search by colour, however you can rank by adding a column, in which you place a ranking value (if you colour code as well you can appear to rank by colour), sorting by the ranking column will give you the same ranked rows together in numerical order.

Sep 11, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

150 people viewed this question

Level 3 Expert

Level 3 Expert