Need help Returning Text

[kygwalt]

what i what to happen is if a x is in cell s5 to return the name Antique White if a x is in cell s6 then return the name Charlerton Coffee Glaze. Below is what I have but it return a #Value! can some one tell me what i'm doing wrong.

=IF(WORKSHEET!S5="X","ANTIQUE WHITE",FALSE),IF(WORKSHEET!S6="X","CHARLERTON COFFEE GLAZE",FALSE)

[benishiryo]

hi kygwalt. you probably need to follow the screen tip of the formulas closely. it's very useful. the IF formula asked for "logical_test", where you input:
WORKSHEET!S5="X"
that is correct. they then asked for a comma before [value_if_true], where you input:
"ANTIQUE WHITE"
again, another comma & they asked for [value_if_false]. to continue with another IF, you cannot put in a FALSE & close the bracket. that ends the screen tip if you noticed.

you should continue with:
=IF(WORKSHEET!S5="X","ANTIQUE WHITE",IF(WORKSHEET!S6="X","CHARLERTON COFFEE GLAZE",FALSE))

you could also return a blank instead:
=IF(WORKSHEET!S5="X","ANTIQUE WHITE",IF(WORKSHEET!S6="X","CHARLERTON COFFEE GLAZE",""))

[kygwalt]

Thanks that works find. I did this before and could not get it to work but wend i put your in there i saw what was wrong i had the wrong page name.


Thanks for the help