Previous Topic Next Topic

If one cell G4 has value 12345 then cell F4 will have....

Solved/Closed
NeedExcelHelpForWork Posts 2 Registration date Tuesday January 26, 2016 Status Member Last seen January 26, 2016 - Jan 26, 2016 at 12:30 PM
 Blocked Profile - Jan 26, 2016 at 01:58 PM
I need help with a basic excel formula. Please :)

If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 will equal USKX.

There's only two possible values for cell G4, 12345 or 54321. If G4 equals 12345 then put USXX in F4 but if G4 equals 54321 then put USKX in F4.

Is this an =IF formula? Can I have 2 values in an =IF formula?

Cheers.

2 responses

Answer 1 / 2
Blocked Profile
Jan 26, 2016 at 12:59 PM
Yes. you can nest if statements:
=if(logic test,true,if(logictest1,true,false))

I hope this helps!
NeedExcelHelpForWork Posts 2 Registration date Tuesday January 26, 2016 Status Member Last seen January 26, 2016
Jan 26, 2016 at 01:50 PM
So my formula would look like this?

=IF(12345,true,IF(54321,USXX,USKX))
Answer 2 / 2
Blocked Profile
Jan 26, 2016 at 01:58 PM
Yes but words have quotes around them, or else excel thinks it is a variable.

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Code to move rows into another sheet based on certain values
Ryleecone -
vcoolio -

6 responses