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

Report
Posts
2
Registration date
Tuesday January 26, 2016
Status
Member
Last seen
January 26, 2016
-
 Blocked Profile -
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 replies


Yes. you can nest if statements:
=if(logic test,true,if(logictest1,true,false))

I hope this helps!
Posts
2
Registration date
Tuesday January 26, 2016
Status
Member
Last seen
January 26, 2016

So my formula would look like this?

=IF(12345,true,IF(54321,USXX,USKX))

Yes but words have quotes around them, or else excel thinks it is a variable.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!