Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i need a formula to fill a cell with a number value based on entries in two adjacent cells. for example, if A1='F' and B1='3', then I would like C1 to autofill with '18'
Solved by A. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/05/2018 - 02:15
Hi there!
User 02/05/2018 - 02:15
hello
Excelchat Expert 02/05/2018 - 02:15
I will be happy to help you with your IF requirement
User 02/05/2018 - 02:15
thank you!
Excelchat Expert 02/05/2018 - 02:16
One question - what should cell C1 be if the criterias are NOT met?
User 02/05/2018 - 02:16
blank is fine
Excelchat Expert 02/05/2018 - 02:17
Ok great
Excelchat Expert 02/05/2018 - 02:18
Check out the formula in cell C1 and let me know if that works for you!
User 02/05/2018 - 02:19
ok, that did work for me
User 02/05/2018 - 02:19
so, i have some new questions now!
User 02/05/2018 - 02:20
is there a way to input multiple 'IF' conditions into the same cell?
Excelchat Expert 02/05/2018 - 02:20
Ok awesome! The thing is... we are only supposed to answer one question per session.
Excelchat Expert 02/05/2018 - 02:20
can answer that one though!
Excelchat Expert 02/05/2018 - 02:20
I
User 02/05/2018 - 02:20
also, I would like the whole column to behave this way
User 02/05/2018 - 02:21
wow yea, that is like the genie's 3 wishes rule
Excelchat Expert 02/05/2018 - 02:21
Absolutely. Give me an example of a multiple IF logic that you would need and I can code it so you can see
Excelchat Expert 02/05/2018 - 02:21
Regarding the whole column to behave this way - you can just drag down the formula (hover mouse over bottom right of cell, until you see the "+" sign, then grab and drag it down)
User 02/05/2018 - 02:22
for instance, if B1=4 instead, then I would like C1=26
User 02/05/2018 - 02:23
ok, thank you, i should have figured about that handle
Excelchat Expert 02/05/2018 - 02:24
oh yes
Excelchat Expert 02/05/2018 - 02:24
let me code that in for you so you can see how to use multiple IF's
User 02/05/2018 - 02:24
okay, thanks!
Excelchat Expert 02/05/2018 - 02:24
You have to use the AND in there as well
Excelchat Expert 02/05/2018 - 02:25
See how I just added the next IF?
User 02/05/2018 - 02:26
don't see that yet...
User 02/05/2018 - 02:26
only see the one IF
User 02/05/2018 - 02:26
i see the AND
User 02/05/2018 - 02:26
=if(and(A1="F",B1=3),18,"")
Excelchat Expert 02/05/2018 - 02:26
Weird!
Excelchat Expert 02/05/2018 - 02:26
=if(and(A1="F",B1=3),18,if(and(A1="F",B1=4),26,""))
Excelchat Expert 02/05/2018 - 02:27
Sometimes the google sheet acts up like this.
User 02/05/2018 - 02:27
ok, no worries. i think i understand the logic
Excelchat Expert 02/05/2018 - 02:27
Beautiful
Excelchat Expert 02/05/2018 - 02:28
Please don't hesitate to ping us back though if you need more help and we can assist with a new session. I hope I added some value!
User 02/05/2018 - 02:28
last clarifying question! if i were to change the position of one of the columns, will the formula still work or should manually input new column entries?
Excelchat Expert 02/05/2018 - 02:28
Oh good one
Excelchat Expert 02/05/2018 - 02:28
Depending on which column you change... you may have to adjust the formula slightly
User 02/05/2018 - 02:28
ok, if it doesn't work then i'll know it didn't automatically change the values
Excelchat Expert 02/05/2018 - 02:28
like if you put the letters in column D instead... A1 would be replaced with D1
Excelchat Expert 02/05/2018 - 02:29
give me an example and I will tell you how it would affect the formula
User 02/05/2018 - 02:30
let's say i cut the C column and inserted it after G, would the formula automatically update its parameters?
Excelchat Expert 02/05/2018 - 02:31
The formula would have to be adjusted, you would just make the cell refrences back to A and B
Excelchat Expert 02/05/2018 - 02:31
there is a way to make them static... but then the auto populating of the column doesn't work
User 02/05/2018 - 02:31
ok, then i would make the change in the row 1 and drag the handle back down to update all
User 02/05/2018 - 02:31
sounds good!
Excelchat Expert 02/05/2018 - 02:32
Yes exactly to the first cell!
Excelchat Expert 02/05/2018 - 02:32
then drag
Excelchat Expert 02/05/2018 - 02:32
Reach back out if you have issues and we will help!
User 02/05/2018 - 02:32
thank you so much, you've been super helpful
Excelchat Expert 02/05/2018 - 02:32
That's great news - thanks!
Excelchat Expert 02/05/2018 - 02:32
have a great day ~
User 02/05/2018 - 02:32
you too!
Excelchat Expert 02/05/2018 - 02:33
:)

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.