If(or(and help

[Alex O]

IF(OR(AND
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m not sure why I’m having so much trouble with this, but I need my formula to perform the following function:
If I>0 or J>0 AND K=0 “FP” IF I>0 or J>0 AND K>0 “90D” IF(AND(I=0,J=0,K=0 “Curr”


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: ARIAL,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 75px"><COL style="WIDTH: 75px"><COL style="WIDTH: 82px"><COL style="WIDTH: 82px"><COL style="WIDTH: 82px"><COL style="WIDTH: 82px"><COL style="WIDTH: 26px"><COL style="WIDTH: 85px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD>


</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD></TR><TR style="HEIGHT: 38px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-WEIGHT: bold">31-60</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-WEIGHT: bold">61-90</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-WEIGHT: bold">Over 90</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-WEIGHT: bold">Total Due (Curr -->90)</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-WEIGHT: bold">Total >30,60,90</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-WEIGHT: bold">Total A/R</TD><TD style="COLOR: #ffffff"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-WEIGHT: bold">First Party Count</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$61.11 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.00 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.91 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$124.05 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$62.02 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$305.56 </TD><TD style="FONT-SIZE: 8pt"></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.00 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$5.54 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$375.14 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$380.68 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$380.68 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$380.68 </TD><TD style="FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: left">90 Day</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.00 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.17 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$16.59 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$16.93 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$16.76 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$16.93 </TD><TD style="FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: left">FALSE</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.00 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$1.46 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$97.50 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$98.96 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$98.96 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$98.96 </TD><TD style="FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: left">FALSE</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$6.25 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.00 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$6.03 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$435.28 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$12.28 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$435.28 </TD><TD style="FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: left">FALSE</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.00 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.16 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$2.32 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$11.23 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$2.48 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$161.33 </TD><TD style="FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: left">FALSE</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$35.95 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$0.00 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$2.60 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$78.55 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$38.55 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt">$275.95 </TD><TD style="FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: left">FALSE</TD></TR></TBODY></TABLE>

 

[Rick Rothstein]

I think this formula will do what you want (put it on Row 4 and copy down)....

=IF(I4+J4,IF(K4=0,"FP","90D"),IF(K4=0,"Curr",""))

Note that last "" in the formula... that covers the condition when (if?) I4 and J4 equal 0, but K4 is greater than 0. Also note that this formula assumes no value can ever be negative.

 

[Alex O]

Elegantly simple! I was making it way more difficult than it needed to be.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks!