Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

IF(and(D<=250,QTY<=40000),600 , IF(and(D<=250,QTY>=40000),600*QTY/40000, IF(and(D>=250 , QTY>=40000) D*QTY/40000)))
Solved by D. Q. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/04/2018 - 12:04
Hi
Excelchat Expert 25/04/2018 - 12:04
Welcome to Got It Pro
Excelchat Expert 25/04/2018 - 12:04
Can you please describe what is D and QTY columns?
User 25/04/2018 - 12:04
D is distance and QTY is quantity
User 25/04/2018 - 12:05
question is can that be made simpler or shorter
User 25/04/2018 - 12:06
hello?
Excelchat Expert 25/04/2018 - 12:07
Hi
Excelchat Expert 25/04/2018 - 12:07
I send a message.
Excelchat Expert 25/04/2018 - 12:07
It was not reached.
Excelchat Expert 25/04/2018 - 12:07
May be a technical problem.
Excelchat Expert 25/04/2018 - 12:07
The formiula can be made little simpler
User 25/04/2018 - 12:08
Great how?
Excelchat Expert 25/04/2018 - 12:08
Iam working on it.
Excelchat Expert 25/04/2018 - 12:09
=IF(D<=250,if(QTY<=40000,600,600*QTY/40000), IF(QTY>=40000,D*QTY/40000,""))
Excelchat Expert 25/04/2018 - 12:09
There is one condition missing.
Excelchat Expert 25/04/2018 - 12:10
In the second condition, if D>250, what is the value for QTY < 40000
User 25/04/2018 - 12:11
is D >250, them 600 providing the QTY remains less than 40000
Excelchat Expert 25/04/2018 - 12:11
Ok.
Excelchat Expert 25/04/2018 - 12:11
=IF(D<=250,if(QTY<=40000,600,600*QTY/40000), IF(QTY>=40000,D*QTY/40000,600))
Excelchat Expert 25/04/2018 - 12:11
Here is the formula
User 25/04/2018 - 12:11
Sorry if D>250 the is D*600
Excelchat Expert 25/04/2018 - 12:11
ok.
Excelchat Expert 25/04/2018 - 12:11
=IF(D<=250,if(QTY<=40000,600,600*QTY/40000), IF(QTY>=40000,D*QTY/40000,D*600))
Excelchat Expert 25/04/2018 - 12:12
Here is the updation.
User 25/04/2018 - 12:14
Yes thank you.
Excelchat Expert 25/04/2018 - 12:14
Thank you.
Excelchat Expert 25/04/2018 - 12:14
Have wonderful day ahead.
Excelchat Expert 25/04/2018 - 12:14
Please do visit Got It Pro.
Excelchat Expert 25/04/2018 - 12:14
Leave valuable rating.

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.