Negative Cell Help

Hello,
I am working with a cell/formula that is for a breakeven analysis. The breakeven is based on savings from a new payment compared to a current payment for a client. I don't have an issue in formatting to a positive number. However, if the number is negative, I want to reflect "zero" but if the number is positive I want it to reflect the actual breakeven as a positive number.

FYI- The formula is formatted in the form of months, although > than 12 months would result in years than months.

TIA to all!

Yes, understand, thanks! I was trying to figure out how to get an example for you to view without loading the entire worksheet. I will work on this and upload it.

Or, are you referencing the Commercial Services Route?

The breakeven is based on savings from a new payment compared to a current payment for a client. I don't have an issue in
formatting to a positive number. However, if the number is negative, I want to reflect "zero" but if the number is positive
I want it to reflect the actual breakeven as a positive number.

FYI- The formula is formatted in the form of months, although > than 12 months would result in years than months.

I am also trying to choose which columns to hide if I don't want them to be shown which I also highlighted in Yellow as well (top).
In other words, being able to omit a specific column if necessary.


Thanks for your help and patience while I learn using this forum.