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.