Only 30 Days Past Due on Invoice ?

D

Dave Elliott

How can I change this so that if the Invoice is not 30 days late, it will
show the Order Amount only ?
And of course if it is 30 days late, then Total both Order Amount and the 2%
!

Thanks,

Dave

=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount]
 
K

Kelvin Lu

Just put [Order Amount] as the false clause of the IIF statement.

"=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount],[Order
Amount])

Kelvin
 
D

Dave Elliott

DONT UNderstand ? Please give syntax so I can see what you mean !

Thanks,

Dave


Kelvin Lu said:
Just put [Order Amount] as the false clause of the IIF statement.

"=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount],[Order
Amount])

Kelvin

Dave Elliott said:
How can I change this so that if the Invoice is not 30 days late, it will
show the Order Amount only ?
And of course if it is 30 days late, then Total both Order Amount and
Click to expand...
the
2%
!

Thanks,

Dave

=IIf([DaysPastDue]<0,CCur([Order Amount])*0.02)+[Order Amount]
Click to expand...
Click to expand...
 

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

0-30 days Past Due Invoice Formula Not Working, Help ! 2
30,60,90 Days Due. 0 to30,31-59,60-89,90-120. 5
30 Days Late on Invoice Question ! 7
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Access Default Microsoft Access Order Entry database issue 0
30 day, 60 day, 90 day, subtract from Order Amount 2
Invoice Form Question 4
Reducing Balance on Invoice 9

Top