simple Excel function help....

Can anyone tell me how to insert a constraint that would give an input such as this.....

A B C D
prod1 2.0 3.2
prod2 3.3 4.1
prod3 4.4 1.2

say if i have teh example above in an excel spreadsheet, and i need in column D constraints, such as:

if column A is 'prod2' , D2=B2*C2*5
and
if column A is 'prod3' , D3=B2*C2*10


any suggestions?

Put following if statement in D2

=if(A2="prod2,B2*C2*5,if(A2="prod3,B2*C2*10,0)

S-

thanks i will try it in a bit

its noyt working.. im not sure if it has a problem recognizing particular text...!?!??!

The attached workbook shows two methods of achieving what you want. The second is the better method as this is more flexible.


Good luck,

Alan.

Thank you so much alan....