how can make formula for this if cell E6 if greater than 0 than the value as its
and if its less than 0 than 0 (no negative numbers)
can somebody please help?

=max(0,e6)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post