**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.*