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.
