Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on formula/paranthesis
Here is the formula i'm trying to use =IF(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(G2="p",I2 ="Acute"),(L2),MIN(F2,L2)) I'm getting the standard error "the formula you typed contains an error". Can anyone see what is wrong? thanks! -- wab_77 ------------------------------------------------------------------------ wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875 View this thread: http://www.excelforum.com/showthread...hreadid=537259 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on formula/paranthesis
Maybe
=IF(AND(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(AND(G 2="p",I2="Acute"),L2,MIN(F 2,L2))) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "wab_77" wrote in message ... Here is the formula i'm trying to use =IF(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(G2="p",I2 ="Acute"),(L2),MIN(F2,L2)) I'm getting the standard error "the formula you typed contains an error". Can anyone see what is wrong? thanks! -- wab_77 ------------------------------------------------------------------------ wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875 View this thread: http://www.excelforum.com/showthread...hreadid=537259 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on formula/paranthesis
wab_77 Wrote: Here is the formula i'm trying to use =IF(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(G2="p",I2 ="Acute"),(L2),MIN(F2,L2)) I'm getting the standard error "the formula you typed contains an error". Can anyone see what is wrong? thanks! Are you trying to do... =IF(AND(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(AND(G 2="P",I2="Acute"),L2,MIN(F2,L2))) -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=537259 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on formula/paranthesis
Maybe
=IF(AND(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(AND(G 2="p",I2="Acute"),(L2),MIN(F2,L2))) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "wab_77" wrote in message ... Here is the formula i'm trying to use =IF(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(G2="p",I2 ="Acute"),(L2),MIN(F2,L2)) I'm getting the standard error "the formula you typed contains an error". Can anyone see what is wrong? thanks! -- wab_77 ------------------------------------------------------------------------ wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875 View this thread: http://www.excelforum.com/showthread...hreadid=537259 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on formula/paranthesis
thanks! I really appreciate it. -- wab_77 ------------------------------------------------------------------------ wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875 View this thread: http://www.excelforum.com/showthread...hreadid=537259 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|