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!

Originally Posted by wab_77

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(G2="P",I2="Acute"),L2,MIN(F2,L2)))

Maybe

=IF(AND(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(AND(G2="p",I2="Acute"),(L2),MIN(F2,L2)))



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"wab_77" <wab_77.26zfam_1146240602.387@excelforum-nospam.com> wrote in
message news:wab_77.26zfam_1146240602.387@excelforum-nospam.com...
>
> 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
>

Maybe

=IF(AND(G2="np",I2="Acute"),MIN(F2,L2,P2),IF(AND(G2="p",I2="Acute"),L2,MIN(F
2,L2)))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"wab_77" <wab_77.26zfam_1146240602.387@excelforum-nospam.com> wrote in
message news:wab_77.26zfam_1146240602.387@excelforum-nospam.com...
>
> 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
>

thanks! I really appreciate it.