Thread: Formula needed
View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default

Admiral70 wrote...
Thanks for such a quick response. I think that will work, I noticed if
the Fee is a negative number it thoughs it off.

I will just have to tell them to not enter negative numbers there.


If you want the savings when fees are negative, use

=IF(Fee0,Fee,Savings)