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

[TABLE="width: 383"]
<tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Sun[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD] [/TD]
[TD]01/07[/TD]
[/TR]
[TR]
[TD]Census[/TD]
[TD]ALF[/TD]
[TD]38[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Memory[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RTF[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total[/TD]
[TD]38[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Hours Allowed[/TD]
[TD]ALF[/TD]
[TD]57.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Memory[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RTF[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Adj for Min[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total[/TD]
[TD]57.00[/TD]
[/TR]
[TR]
[TD]Effective Ratio[/TD]
[TD] [/TD]
[TD]1.50[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Actual Hours[/TD]
[TD]Regular[/TD]
[TD]48.50[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Overtime[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Agency[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total[/TD]
[TD]48.50[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Over/Under[/TD]
[TD] [/TD]
[TD]-8.50[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MET/OUT![/TD]
[TD] [/TD]
[TD]#VALUE ![/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]47.86[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[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.