View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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