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 - Last answered 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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!