Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.