View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lena Lena is offline
external usenet poster
 
Posts: 19
Default Result not less than 0

I'm doing mortgage calculations such as
=-CUMIPMT(H13/12,H14*12,H12,1,12,0)and can't figure out how to have a result
that, when the result is a negative number, zero is entered by default.