Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc