formula question

[Rob]

B55 calculates the difference of two values
B56 calculates square root of B55
I want to set B56 to zero if B55 is negative.

How do I do this?

Thank you,
Rob

Excel 2003 (11.6355.6568) SP1

 

[Domenic]

Try...

=IF(B55>0,B55^2,0)

Hope this helps!

 

[Rob]

Never-mind. I got it.

Thanks,
Rob

 

[ChuckF]

=if(b55<0,"0",SQRT(B55))
HTH

 

[Dana DeLouis]

One way: =SQRT(MAX(B55,0))