HELP!!im trying to set-up a formula in where when I write a certain name example "stm" it will refelct a percentage in the next tab.

[Omarfeloose]

im trying to set-up a formula in where when I write a certain name example "stm" it will refelct a percentage in the next tab.

so far ive gotten to this poisnt but i keep getting an error message!!


=IF(A5="STM",PRODUCT(0),IF(A5="ERM",PRODUCT(0)),IF(A5="FRT",PRODUCT (.22))

Why is the third link wrong?

 

[scottylad2]

=IF(A5="STM",PRODUCT(0),IF(A5="ERM",PRODUCT(0)),IF(A5="FRT",PRODUCT (.22)))

Why is the third link wrong?

What does PRODUCT(0) represent? If it's an actual item and thats the word you want displayed in the cell then you should enclose it in quotes "PRODUCT(0)" and likewise with the next two IF's.

Your also missing a parenthesis at the end of the statement

 

[Omarfeloose]

(o) refers to 0.00% but TY...you helped me figure out the missing perenthesis!