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.

Kmspico password 12345 not working
Kmspico - Download - Other
Kmspico password - Word Forum
Winrar password not working - Guide
Password request - Phones, PDA & GPS Forum
No email no password - Guide

2 responses

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.

Similar discussions

Zip password :- what is the zip password?

New password

kmspico password protected

I need a password for this kmspico files

Password does not work

Similar discussions

Subscribe To Our Newsletter!