Excel 2007 : Combining IF Functions together....

**qhx398** · 12-11-2009, 02:46 AM

Hi Everyone,

Today in my data management class, my teacher gave us this file and also gave us a workbook to work through. I'm on the part where they ask to use the IF function to determine what to charge the customer for delivery. It looks up the correct value in the data table and returns the price dependant on how many miles entered. They started me off with =IF(C6<=5,0_to_5,(IF...). I attempted to combine it and add the rest of the categories but it only returns "FALSE" instead of a price. Below is a link to the workbook I have, so you can see what I'm doing wrong. Thanks for all your help in advance!

Excel file: ftp://public@ftp1.freeservz.com/Furniture Sales.xls

**qhx398** · 12-11-2009, 02:52 AM

Sorry everyone, the above link isnt clickable since the filename has a space in it. The forum won't let me edit my post so here's the new link....

ftp://public@ftp1.freeservz.com/FurnitureSales.xls

**ConneXionLost** · 12-11-2009, 02:57 AM

Hi qhx398,

That link requires a password. This web forum does accommodate uploading of Excel files as attachments. It would be a preferred approach.

Also, please ensure this isn't a homework assignment.

Cheers,

**Ajmal Mirza** · 12-11-2009, 03:11 AM

Originally Posted by qhx398

Hi Everyone,

Today in my data management class, my teacher gave us this file and also gave us a workbook to work through. I'm on the part where they ask to use the IF function to determine what to charge the customer for delivery. It looks up the correct value in the data table and returns the price dependant on how many miles entered. They started me off with =IF(C6<=5,0_to_5,(IF...). I attempted to combine it and add the rest of the categories but it only returns "FALSE" instead of a price. Below is a link to the workbook I have, so you can see what I'm doing wrong. Thanks for all your help in advance!

Excel file: ftp://public@ftp1.freeservz.com/Furniture Sales.xls

Dear Friend,

While the easy and correct way would have been to use 'vlookup' function, still I have done the same with 'IF' function.

You can check the same in the attached file. You have to give further 'if' function ('if' within 'if') for getting the result

**pike** · 12-11-2009, 03:23 AM

Hi Ajmal Mirza
The functions work for me or am I missing something?

**pike** · 12-11-2009, 03:27 AM

yep I'm missing a brain
try
=VLOOKUP(C6,F4:H10,3,1)

**Ajmal Mirza** · 12-11-2009, 03:35 AM

Yes.. I had wrongly put '2' instead of '3' in vlookup.

The correct function would be =VLOOKUP(C6,F4:H10,3,1)

The cell should now contain the same answer

i.e.

C8 = D8, where C8 is calculated by vlookup & D8 is calculated by 'if' function