I have a formula that I'm using in Excel to determine what the payback of a value is after "X" of months. But I'd like to modify the formula to display 0 or $0.00 if the result of the formula is less than $0.00
The current formula is
=C2-(C2*(G2/24))
But is there a way I can make this so once the value hits 0 or less than 0, it would simply display $0.00
Thanks,
You can use something like:
to return a 0 result if the result would have otherwise been negative.