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.

If one cell G4 has value 12345 then cell F4 will have....
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
If cell contains date then return value ✓ - Excel Forum
Esc f1 f4 blinking - Laptop Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Conditional formatting if cell contains text - Excel Forum

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

Excel - IF function with multiple words

If cell = date return yes or no.

If a cell contains any text then add a value

Counting cells containing only numbers

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!