Slight adjustment needed to formula!

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I want to change it slightly in that if Q1139 is more than zero "MORE THAN
60 DAYS OVERDUE" not if Z1139 and Q1139 were the same
=IF(Z1139="","",IF(Z1139<0,"CREDIT",IF(Z1139=0,"",IF(AND(Z1140=Q1139,Q1139<>
""),"MORE THAN 60 DAYS OVERDUE-->","30 DAY OVERDUE AMOUNT, IGNORE IF
PAID-->"))))
--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Hi Bob
try
""),"MORE THAN 60 DAYS OVERDUE-->","30 DAY OVERDUE AMOUNT, IGNORE IF
PAID-->"))))


--
Regards
Frank Kabel
Frankfurt, Germany
I want to change it slightly in that if Q1139 is more than zero "MORE
THAN 60 DAYS OVERDUE" not if Z1139 and Q1139 were the same
Click to expand...
=IF(Z1139="","",IF(Z1139<0,"CREDIT",IF(Z1139=0,"",IF(AND(Z1140=Q1139,Q1
 
Back
Top