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]

 

[jtakw]

Hi,

What is C250 in your formula?

 

[Lotus User]

sorry, typo it's C25

 

[Norie]

When I try your formula with the posted values the result of the formula is 'OUT'.

Have you checked that all the values in the relevant cells are actually numeric?

 

[Lotus User]

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

This is actually my formula...not sure how I cut and paste it incorrectly....

 

[Lotus User]

my copy and paste isn't working...the value should be MET

let me try to share my formula again..

 

[Jonmo1]

It's the forum software, treating < and > characters as html code tags.

Put spaces around < and > characters when posting formulas.

 

[Lotus User]

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

...it comes down to the last segment of which C27 is less than zero so the answer should be MET

 

[Lotus User]

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

I'm sorry to keep trying to post my formula but it won't post what I am copying here....

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

 

[Norie]

Is this the formula in words?

If C13 and C25 and C27 are less than zero, 'MIN-OUT'

Else If C27 less than zero, 'MET'

Else 'OUT'

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