If statement with TEXT?

[PotatoFro]

is possible to create an IF function with text variables?

i'm trying to create an inventory database that can handle severa
different products in the inventory, and can add and subtract from th
total number of that product that is in the inventory. the way th
inventory database is set up i have given the product text ID's.. an
it'd be easiest if i could use those. Do i just have to change them t
some form of numeric ID for this to work?

thanks so much
jaco

 

[JulieD]

Hi Jacob

using text with an IF function is fine .. you've just got to remember than
any text in any formula or function needs to be enclosed in ""
e.g.
=IF(A1="Cat","Meow","Squeak")

(but from the rest of your post the VLOOKUP function might be more
suitable.)

Hope this helps
Cheers
JulieD