formulas

[phil parker]

I have entered a formula into a spreadsheet the formula
is =SUM(E9/46)now if the sum is negative i.e.-12 i want
excel to display a zero and if it is positive i want it
to display the reqiured figure how do i tell it to do
this ????

Please help

 

[Frank Kabel]

Hi
first: no need for using SUM
=E9/46 would give you the same result.

But to your question: Try
=MAX(E9/46,0)