Getting #value error with nested if statements

[Lotus User]

The formula I am using is:

=IF(AND(C13>0,C25<C30),"MIN-OUT"),IF(AND(C18>0,C27<0),"MIN-OUT",IF(C27<=0,"MET","OUT"))

My formula is in cell C29 and I am getting the #VALUE ERROR. I've checked all the cell formatting and they are all set to number. Any suggestions?
Here is the data. Can't figure out how to do an actual screen shot post.

C13=38
C25=48.50
C3047.86
C18=0.00
C27=-8.50

		Sun
Date		01/07
Census	ALF	38
	Memory
	RTF
	Total	38
Hours Allowed	ALF	57.00
	Memory	0.00
	RTF	0.00
	Adj for Min	0.00
	Total	57.00
Effective Ratio		1.50
Actual Hours	Regular	48.50
	Overtime
	Agency
	Total	48.50
Over/Under		-8.50
MET/OUT!		#VALUE !
		47.86

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[Lotus User]

Ok...hold on

 

[Lotus User]

No, c25< 47.86(the value in cell c30)

 

[Jonmo1]

<c30),"min-out"),if(and(c18>keep trying to post my formula but it won't post what I am copying here....<c30),"min-out"),if(and(c18>

Did you see post #7 ?

</c30),"min-out"),if(and(c18></c30),"min-out"),if(and(c18>

 

[Lotus User]

=IF(AND(C13>0,C25 < C30),"MIN-OUT"),IF(AND(C18 > 0,C27 < 0),"MIN-OUT",IF(C27 < =0,"MET","OUT"))

hopefully THIS formula posts correctly

 

[Jonmo1]

=IF(AND(C13>0,C25 < C30),"MIN-OUT"),IF(AND(C18 > 0,C27 < 0),"MIN-OUT",IF(C27 < =0,"MET","OUT"))

Looks like misplaced )
Should be
=IF(AND(C13>0,C25 < C30),"MIN-OUT",IF(AND(C18 > 0,C27 < 0),"MIN-OUT",IF(C27 < =0,"MET","OUT")))

 

[Lotus User]

Perfect! THANK YOU SO MUCH!!!

 

[Jonmo1]

You're welcome.