Slight adjustment needed to formula!

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

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjustment needed for formula 5
Conditional formatting dates? 8
Addition needed to formula? 9
Formula needed 22
Extension needed to formula 4
Simple Formula needed please! 4
TextBox Question! 7
Text Box Question 1

Top