View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
2rrs 2rrs is offline
external usenet poster
 
Posts: 1
Default PAYMENT CALCULATIONS

Hi Mark,

Put a minus sign like so =-PMT

That will make it positive

2rrs


"MARK AKKERMAN" wrote in message ...
Hello Sir,

Sorry for the yelling, it was only a caps lock I assure
you. Thank you for giving me the answer I have been
looking for. I have only one problem, when I calculate it
on my excel program, it comes out the same as yours to the
penny, but in a negative number.

Thanks again,

Mark.
-----Original Message-----