Thread: [Solved] if (neg) show 0
View Single Post
 
Old 09-16-2008, 01:47 PM
rtankersley rtankersley is offline
Novice
  
Join Date: Sep 2008
Location: Frankfort Kentucky
Posts: 8
rtankersley is on a distinguished road
Default
For the first one try

=IF(SUM(A18-A17)*(100)<0,0,SUM(A18-A17)*(100))

If that works apply the same logic to the second. If you need further help just ask.
Reply With Quote