Looking for formula help

[changetires]

I know there is a way just dont know the codes for doing it. Any help
would be appreciated.

Cell D1 has this =(A1*B1*C1)

But I also want to add if cell X1 has failed written in it then I want
cell D1 to calculate A1*B1.

Basically cell D1 will have to chose which formula it is going to use.

any help?

Thanks

Ed

 

[changetires]

Mally something about it didnt work. Anything else I could try? I am
steadily working on it to see if I can figure it out.

Ed

 

[changetires]

Mally,

It did work thanks for the help.

Ed

 

[Bernard Liengme]

It must work!
What values do you get with X1 FAILED and equal to PASSED?
Also try
=MAX(A1*B1, A1*B1*D1*(X1="FAILED"))
I am assuming all values are positive.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"changetires" <[email protected]>
wrote in message
news:[email protected]...