**Question description:**

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

I need to type in a number which will we call X. I then need a formula in another cell, so that if the X is 301 or greater the cell will reader X+100. At the same time I need it to forumla if X is 300 or less it will read X+50

Solved by T. W. in 7 mins

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

Excelchat Expert
15/06/2018 - 12:43

Hello and welcome to Got It! :)

User
15/06/2018 - 12:43

Hi there :)

Excelchat Expert
15/06/2018 - 12:43

I've read your concern, and it seems you want to add 100 to the X number if it is 301 or greater. Otherwise, you want to add 50 to X. We can do this by setting an example in the document preview. :)

User
15/06/2018 - 12:44

yeah thats correct, i always ask these questions when its a simple one, yet i can make a crazy concatenate fine haha

Excelchat Expert
15/06/2018 - 12:45

Lol, okay. Nice then! So basically, what we have in cell C3 is an IF statement.

User
15/06/2018 - 12:45

sorry i meant - not + but thats a simple change

Excelchat Expert
15/06/2018 - 12:45

So IF C2 is equal to or more than 301, it adds 100. However, if C2 is equal to or less than 300, it adds 50. :)

Excelchat Expert
15/06/2018 - 12:46

Oh I see. Yeah we can change that. :)

Excelchat Expert
15/06/2018 - 12:46

Already done! :)

User
15/06/2018 - 12:46

the number will never be less than 200 anyway, i would explain what it's for but it wouldnt make much sense haha. thanks!

Excelchat Expert
15/06/2018 - 12:47

Oh, lol I see! Okay, any questions btw on the provided solution? :)

User
15/06/2018 - 12:47

so basically, youre saying if C2 then just adding " " as a rule and " " as a rule, then in another set of brackets setting what the rule should be? sort of thing?

User
15/06/2018 - 12:48

so the quotations tell it how many rules to look out for?

Excelchat Expert
15/06/2018 - 12:48

Oh, I added that IF C2 = "" (meaning it's blank), C3 would just be blank as well.

Excelchat Expert
15/06/2018 - 12:48

The "" means blank in excel formulas. :)

Excelchat Expert
15/06/2018 - 12:49

We need to do that because Excell interprets a blank cell as 0, and thus if it detects that it is less than 300, it subtracts 50 from 0. :)

User
15/06/2018 - 12:49

yeah im with you. that's great though, saved me a while figuring it out!

Excelchat Expert
15/06/2018 - 12:49

Nice then! :)

Excelchat Expert
15/06/2018 - 12:49

Btw, you can download a copy of the document preview by going to File > Download as > Microsoft Excel (.xlsx). The formulas will be downloaded as well. :)

User
15/06/2018 - 12:50

Okay thats great thanks!

Excelchat Expert
15/06/2018 - 12:50

Nice! If all is good now, please do end the session via the button on the upper right of your screen (sorry, can't do it from our end). Please do leave a good feedback upon your exit. Thanks so much and have a nice day! :)

User
15/06/2018 - 12:50

Thank you for your help! Take Care!

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