**Question description:**

*This user has given permission to use the problem statement for this blog.*

im trying to add two if statements. its not working
=IF(Q7="<3,0,Q7,IF(q7=">100,100,Q7)

Solved by V. L. in 11 mins

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

Excelchat Expert
05/10/2018 - 11:56

Hi…Welcome to Got It Pro. I see that your question is about fixing formulas.

Excelchat Expert
05/10/2018 - 11:57

I can help you with that problem.

Excelchat Expert
05/10/2018 - 11:57

Before we get started, this is a quick reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.

User
05/10/2018 - 11:57

i just copied the sheet

[Uploaded an Excel file]

Excelchat Expert
05/10/2018 - 11:57

Thanks for sharing the file.

Excelchat Expert
05/10/2018 - 11:58

Could you please tell me the logic you are trying to apply through this formula?

Excelchat Expert
05/10/2018 - 11:59

And just to confirm, the formula that you are referring is in column N, is that right?

User
05/10/2018 - 11:59

im trying to bring back 0 if the qty in q3 is less than 3 if its more than 100 then bring back 100 or the actual quantity

User
05/10/2018 - 11:59

yes that is correcy

User
05/10/2018 - 12:00

sorry typos keyboard is broken

Excelchat Expert
05/10/2018 - 12:00

No problem :) I can understand

Excelchat Expert
05/10/2018 - 12:01

So <3 should be 0

Excelchat Expert
05/10/2018 - 12:01

>100 should be 100

User
05/10/2018 - 12:01

yes

Excelchat Expert
05/10/2018 - 12:01

between 3 & 100, actual quantity

User
05/10/2018 - 12:01

yes...

Excelchat Expert
05/10/2018 - 12:01

Is that correct?

User
05/10/2018 - 12:01

correct

Excelchat Expert
05/10/2018 - 12:01

Perfect, let me rectify your formula.

Excelchat Expert
05/10/2018 - 12:03

Do you need this formula only till row 42?

User
05/10/2018 - 12:04

no- thru end of sheet

Excelchat Expert
05/10/2018 - 12:04

The rectified formula to be placed in N3 =IF(Q3<3,0,IF(Q3>100,100,Q3))

Excelchat Expert
05/10/2018 - 12:04

This same formula can be copied all the way down.

User
05/10/2018 - 12:05

ahhh i had way to many arguemnts going on

User
05/10/2018 - 12:05

thiswas easy... thank you

Excelchat Expert
05/10/2018 - 12:05

[Uploaded an Excel file]

Excelchat Expert
05/10/2018 - 12:06

I have uploaded the file with the rectified formula.

User
05/10/2018 - 12:06

thank yiu

Excelchat Expert
05/10/2018 - 12:06

You were almost there, just some syntax issue :)

Excelchat Expert
05/10/2018 - 12:06

Is there anything else I can help you with this query?

User
05/10/2018 - 12:06

no this is perfect

Excelchat Expert
05/10/2018 - 12:06

Please feel free to leave any comments or feedback.

User
05/10/2018 - 12:07

i will

Excelchat Expert
05/10/2018 - 12:07

Thanks for your time. Please do come back for any new question. You can now end this session. Have a great day ahead!

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