help on formula/paranthesis

W

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!
 
B

Bob Phillips

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)
 
M

Morrigan

wab_77 said:
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!
Click to expand...



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)))
 
Top