Thread
:
Result not less than 0
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Lena
external usenet poster
Posts: 19
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.
Reply With Quote
Lena
View Public Profile
Find all posts by Lena