If Function

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

I want to do an if function where even if the answer is
below zero it will remain zero. If it is over zero then an
equation is done. When I do it it looks right, but the
value of the cell is still the negative value to excel.
So when I sum the column I get what looks like a wrong
answer( it is correct using the negative number). How do
you get it to sum the visual value and not the actual
value? Maybe the if function was the wrong way to go?
 
That worked perfect -Thanks
-----Original Message-----
Hi
try
=MAX(0,your_formula)

if this does not help you may post your current formula

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Back
Top