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