| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
