Looking for formula help
 

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
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=553180

Looking for formula help
 

if(X1="failed",A1*B1,A1*B1*C1)


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553180

Looking for formula help
 

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
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=553180

Looking for formula help
 

Mally,

It did work thanks for the help.

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=553180

Looking for formula help
 

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"
wrote in message
...

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
------------------------------------------------------------------------
changetires's Profile:
http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=553180