**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi, I'm trying to use the IF-AND formula to return an value from two cells in excel but can't get it to work so could someone take a look and advise please?
So far I have got -
=IF((AND (E4 =â??2â?,F4<0.6),â??Â£45â?,
IF((AND (E4 =â??2â?,F4>0.6),â??Â£60â?,
IF((AND (E4 =â??2â?,F4>1),â??Â£85â?,
IF((AND (E4 =â??1â?, F4<0.1),â??Â£12â?,
IF((AND (E4 =â??1â?, F4<0.15),â??Â£15â?,
IF((AND (E4 =â??1â?, F4<0.175),â??Â£18â?,
IF((AND (E4 =â??1â?, F4>0.176),â??Â£24â?,
IF((AND (E4 =â??Courierâ?, F4<0.1),â??Â£12â?,
IF((AND (E4 =â??Courierâ?, F4 <0.15),â??Â£15â?,
IF((AND (E4 =â??Courierâ?, F4 <0.175),â??Â£18â?,
IF((AND (E4 =â??Courierâ?, F4 >0.176),â??Â£24â?))))))))))))))))))))))

Solved by A. L. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
20/08/2018 - 08:52

Hi

User
20/08/2018 - 08:52

Hi

Excelchat Expert
20/08/2018 - 08:52

Could you please elaborate on the issue

User
20/08/2018 - 08:53

Sure.

User
20/08/2018 - 08:54

I am trying to set up a formula that returns the cost of a delivery to a customer. The deliveries are made by either 1 or 2 people and the cost for both services are dependant on the size of the piece of furniture being delivered.

User
20/08/2018 - 08:55

I have two columns, one for the size and the other for the service type, so all I need to work out is how to merge each service with the relevant size to return the delivery cost....

User
20/08/2018 - 08:56

Hope this makes sense!!

Excelchat Expert
20/08/2018 - 08:56

I assume e4 is either 1 or 2?

User
20/08/2018 - 08:56

Yes, E4 is the service type

User
20/08/2018 - 08:57

Do you want to see the delivery info?

Excelchat Expert
20/08/2018 - 08:57

For 1, <=0.6 = 45

Excelchat Expert
20/08/2018 - 08:57

>0.6 = 60

Excelchat Expert
20/08/2018 - 08:58

>1= 85

User
20/08/2018 - 08:59

No, that is the two man service......

Excelchat Expert
20/08/2018 - 08:59

sorry, yes 2

User
20/08/2018 - 09:00

:)

Excelchat Expert
20/08/2018 - 09:01

And for 1 it is, <=0.1 : 12,

Excelchat Expert
20/08/2018 - 09:02

<=0.15 : 15

Excelchat Expert
20/08/2018 - 09:02

<=0.175 : 18

Excelchat Expert
20/08/2018 - 09:02

>175 24

Excelchat Expert
20/08/2018 - 09:03

E4 could also be courier?

User
20/08/2018 - 09:03

Yes but - >0.175 24 and yes it could be courier

Excelchat Expert
20/08/2018 - 09:04

In case of courier or 1, the rates are same, right?

User
20/08/2018 - 09:05

Yes

Excelchat Expert
20/08/2018 - 09:07

I have created the formula in the preview sheet in cell B6

User
20/08/2018 - 09:08

Thank you, can you hang on while I try it in my spreadsheet. It looks a lot more simple than mine lol!!!

Excelchat Expert
20/08/2018 - 09:09

sure

User
20/08/2018 - 09:11

Hi, that's great, thank you - I have been trying to sort this all weekend!

Excelchat Expert
20/08/2018 - 09:12

you are welcome

User
20/08/2018 - 09:12

Thanks again for your help, have a great day :) Byeeee!!

Excelchat Expert
20/08/2018 - 09:12

You too have a great day

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*