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.

If one cell G4 has value 12345 then cell F4 will have....
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
If cell contains specific text then return value in another cell vba ✓ - Excel Forum
Count if cell contains number - Excel Forum
If cell contains date then return value ✓ - Office Software Forum

2 replies

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.

Subscribe To Our Newsletter!