**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 O. B. in 18 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
24/04/2018 - 11:44

Hi

Excelchat Expert
24/04/2018 - 11:44

Welcome to Got it Pro

User
24/04/2018 - 11:44

Hello, thank you

Excelchat Expert
24/04/2018 - 11:45

Can you paste you sample data so that i can help you better

Excelchat Expert
24/04/2018 - 11:46

Are you there?

User
24/04/2018 - 11:46

sure one minute

Excelchat Expert
24/04/2018 - 11:46

ok

User
24/04/2018 - 11:46

I need to type it again in your spreadsheet. it will take me a minute is that ok?

Excelchat Expert
24/04/2018 - 11:46

ok

Excelchat Expert
24/04/2018 - 11:49

are you pasting?

User
24/04/2018 - 11:50

no just typed it but htat is pretty much it. Can you understand what I need?

User
24/04/2018 - 11:50

I need this to be simpler

Excelchat Expert
24/04/2018 - 11:50

That is the formula but that is not correct

Excelchat Expert
24/04/2018 - 11:50

can you paste your data on which this formula needs to be applied

User
24/04/2018 - 11:50

the formula is correct as far as the answe i need but it seem verey long.

User
24/04/2018 - 11:51

this is all I got.

Excelchat Expert
24/04/2018 - 11:51

yes it is correct now

Excelchat Expert
24/04/2018 - 11:51

why is it an issue if it s long

User
24/04/2018 - 11:52

Can this formula be made more simple or smaller

User
24/04/2018 - 11:52

Yes, that is correct it is too long

Excelchat Expert
24/04/2018 - 11:53

what exactly you want

Excelchat Expert
24/04/2018 - 11:53

tell me

Excelchat Expert
24/04/2018 - 11:53

i will build the formula

User
24/04/2018 - 11:54

if my distance is less than 250 miles and m y load is less than 40000, them is only 600

User
24/04/2018 - 11:55

IF my distance still less than 250 miles but my load is greater than 40000, then 600 * load/40000

User
24/04/2018 - 11:55

if my distance is greater than 250 miles and my l oad is greater than 40000, them what ever the distance is * load/40000

User
24/04/2018 - 11:56

Do you se e it?

Excelchat Expert
24/04/2018 - 11:56

Yes

Excelchat Expert
24/04/2018 - 11:56

that is exactly in your formula

User
24/04/2018 - 11:57

Yes but is too long. Can it be made simpler or shorter is the issue

User
24/04/2018 - 11:57

IF not them ????

Excelchat Expert
24/04/2018 - 11:57

If i would have written the formula i would have used it like you have done

User
24/04/2018 - 11:58

ok so that is as good as it gets I quess

Excelchat Expert
24/04/2018 - 11:58

what is A1>250

User
24/04/2018 - 11:58

A1 is the distance and 250 is miles

Excelchat Expert
24/04/2018 - 11:58

and b1<40000

User
24/04/2018 - 11:59

load less than 40000

Excelchat Expert
24/04/2018 - 11:59

what is A1>250 and B1<40000

Excelchat Expert
24/04/2018 - 11:59

what if?

Excelchat Expert
24/04/2018 - 11:59

i mean what if

User
24/04/2018 - 11:59

load is greater than 250 and load less than 40000

User
24/04/2018 - 11:59

what if? dont understand

Excelchat Expert
24/04/2018 - 11:59

see formula now

User
24/04/2018 - 11:59

The issues is can it be made simpler

Excelchat Expert
25/04/2018 - 12:00

i put 10000 is A1

Excelchat Expert
25/04/2018 - 12:00

earlier flase was coming

User
25/04/2018 - 12:00

still the same formula I put up. The point is can you make it smaller

Excelchat Expert
25/04/2018 - 12:00

false*

Excelchat Expert
25/04/2018 - 12:01

I cannot but it is the right formula and i would have also written it the same way

Excelchat Expert
25/04/2018 - 12:01

you have 3 if conditions with AND

User
25/04/2018 - 12:01

ok, thank you

Excelchat Expert
25/04/2018 - 12:01

So 6 times it would be written

User
25/04/2018 - 12:01

ok

Excelchat Expert
25/04/2018 - 12:01

That is what i am trying to tell

Excelchat Expert
25/04/2018 - 12:02

Please do give good rating

User
25/04/2018 - 12:02

thank you

Excelchat Expert
25/04/2018 - 12:02

i want to help you but this is the best way to write the formula

User
25/04/2018 - 12:02

ok

Excelchat Expert
25/04/2018 - 12:02

i hope you understand

User
25/04/2018 - 12:02

yes

Excelchat Expert
25/04/2018 - 12:02

It is a perfect formula

User
25/04/2018 - 12:02

thank you

Excelchat Expert
25/04/2018 - 12:02

Have a good 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.*