Thread: Public Function
View Single Post
  #10   Report Post  
Monty
 
Posts: n/a
Default

Sorry got this working okay

thanks for all your help

Monty

"Monty" wrote:

what cell would i put this into

"JE McGimpsey" wrote:

One way:

=IF((C1-B1)=15,PromptPayment()+C1-B1,C1-B1)

In article ,
"Monty" wrote:

When you hit the ok button in the message box the cell reverts back to zero,
can this be changed so the correct amount of days are shown even if they are
over 15.