Report

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

Ask a question NeedExcelHelpForWork 2Posts Tuesday January 26, 2016Registration date January 26, 2016 Last seen - Latest answer on Jan 26, 2016 01:58PM
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.
See more 
Helpful
+0
moins plus
Yes. you can nest if statements:
=if(logic test,true,if(logictest1,true,false))

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

=IF(12345,true,IF(54321,USXX,USKX))
Reply
Add comment
Helpful
+0
moins plus
Yes but words have quotes around them, or else excel thinks it is a variable.
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!