formula question "Rob" <fake[ at ]address.com> 01.09.2006 14:33:25 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

Re: formula question Domenic <domenic22[ at ]sympatico.ca> 01.09.2006 14:48:05 Try... =IF(B55>0,B55^2,0) Hope this helps! In article <#BN7HPdzGHA.4116[ at ]TK2MSFTNGP02.phx.gbl>, "Rob" <fake[ at ]address.com> wrote: [Quoted Text] > 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

Re: formula question "Rob" <fake[ at ]address.com> 01.09.2006 14:48:53 Never-mind. I got it. Thanks, Rob "Rob" <fake[ at ]address.com> wrote in message news:%23BN7HPdzGHA.4116[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > 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 > >

Re: formula question "ChuckF" <CharlesTFisher[ at ]msn.com> 01.09.2006 14:54:52 =if(b55<0,"0",SQRT(B55)) HTH Rob wrote: [Quoted Text] > 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

Re: formula question "Dana DeLouis" <ddelouis[ at ]bellsouth.net> 01.09.2006 15:34:49 One way: =SQRT(MAX(B55,0)) -- Dana DeLouis Windows XP, Office 2003 "Rob" <fake[ at ]address.com> wrote in message news:%23BN7HPdzGHA.4116[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > 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