formula question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 01 Sep 2006 15:33 GMT

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

Reply to this Message

Domenic - 01 Sep 2006 15:48 GMT

Try...

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

Hope this helps!

> B55 calculates the difference of two values
> B56 calculates square root of B55
[quoted text clipped - 6 lines]
>
> Excel 2003 (11.6355.6568) SP1

Reply to this Message

Rob - 01 Sep 2006 15:48 GMT

Never-mind. I got it.

Thanks,
Rob

> B55 calculates the difference of two values
> B56 calculates square root of B55
[quoted text clipped - 6 lines]
>
> Excel 2003 (11.6355.6568) SP1

Reply to this Message

ChuckF - 01 Sep 2006 15:54 GMT

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

> B55 calculates the difference of two values
> B56 calculates square root of B55
[quoted text clipped - 6 lines]
>
> Excel 2003 (11.6355.6568) SP1

Reply to this Message

Dana DeLouis - 01 Sep 2006 16:34 GMT

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

Signature

Dana DeLouis
Windows XP, Office 2003

> B55 calculates the difference of two values
> B56 calculates square root of B55
[quoted text clipped - 6 lines]
>
> Excel 2003 (11.6355.6568) SP1

Reply to this Message