Report

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

Ask a question NeedExcelHelpForWork 2Posts Tuesday January 26, 2016Registration date January 26, 2016 Last seen - Last answered on Jan 26, 2016 at 01:58 PM by ac3mark
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
plus moins
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 at 01:50 PM
So my formula would look like this?

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

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!