software

Here is the formula i'm trying to use
=IF(G2=quot;npquot;,I2=quot;Acutequot;),MIN(F2,L2,P2),IF(G2=quot;pquot;,I2 =quot;Acutequot;),(L2),MIN(F2,L2))

I'm getting the standard error quot;the formula you typed contains an
errorquot;.

Can anyone see what is wrong?

thanks!--
wab_77
------------------------------------------------------------------------
wab_77's Profile: www.excelforum.com/member.php...oamp;userid=33875
View this thread: www.excelforum.com/showthread...hreadid=537259Maybe

=IF(AND(G2=quot;npquot;,I2=quot;Acutequot;),MIN(F2,L2,P2),IF(AND(G 2=quot;pquot;,I2=quot;Acutequot;),L2,MIN(F
2,L2)))--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;wab_77quot; gt; wrote in
message ...
gt;
gt; Here is the formula i'm trying to use
gt;
=IF(G2=quot;npquot;,I2=quot;Acutequot;),MIN(F2,L2,P2),IF(G2=quot;pquot;,I2 =quot;Acutequot;),(L2),MIN(F2,L2))
gt;
gt; I'm getting the standard error quot;the formula you typed contains an
gt; errorquot;.
gt;
gt; Can anyone see what is wrong?
gt;
gt; thanks!
gt;
gt;
gt; --
gt; wab_77
gt; ------------------------------------------------------------------------
gt; wab_77's Profile:
www.excelforum.com/member.php...oamp;userid=33875
gt; View this thread: www.excelforum.com/showthread...hreadid=537259
gt;

wab_77 Wrote:
gt; Here is the formula i'm trying to use
gt; =IF(G2=quot;npquot;,I2=quot;Acutequot;),MIN(F2,L2,P2),IF(G2=quot;pquot;,I2 =quot;Acutequot;),(L2),MIN(F2,L2))
gt;
gt; I'm getting the standard error quot;the formula you typed contains an
gt; errorquot;.
gt;
gt; Can anyone see what is wrong?
gt;
gt; thanks!
Are you trying to do...

=IF(AND(G2=quot;npquot;,I2=quot;Acutequot;),MIN(F2,L2,P2),IF(AND(G 2=quot;Pquot;,I2=quot;Acutequot;),L2,MIN(F2,L2)))--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: www.excelforum.com/member.php...foamp;userid=7094
View this thread: www.excelforum.com/showthread...hreadid=537259Maybe

=IF(AND(G2=quot;npquot;,I2=quot;Acutequot;),MIN(F2,L2,P2),IF(AND(G 2=quot;pquot;,I2=quot;Acutequot;),(L2),MIN(F2,L2)))
--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;wab_77quot; gt; wrote in
message ...
gt;
gt; Here is the formula i'm trying to use
gt; =IF(G2=quot;npquot;,I2=quot;Acutequot;),MIN(F2,L2,P2),IF(G2=quot;pquot;,I2 =quot;Acutequot;),(L2),MIN(F2,L2))
gt;
gt; I'm getting the standard error quot;the formula you typed contains an
gt; errorquot;.
gt;
gt; Can anyone see what is wrong?
gt;
gt; thanks!
gt;
gt;
gt; --
gt; wab_77
gt; ------------------------------------------------------------------------
gt; wab_77's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33875
gt; View this thread: www.excelforum.com/showthread...hreadid=537259
gt;

thanks! I really appreciate it.--
wab_77
------------------------------------------------------------------------
wab_77's Profile: www.excelforum.com/member.php...oamp;userid=33875
View this thread: www.excelforum.com/showthread...hreadid=537259