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