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.