From: Dewayne on 30 Apr 2010 19:51 This is what I need to accomplish in H15: IF D30=0,0 IF E15/D45 = J30 return the value of E15/D45 otherwise "Error" I've been playing with this for some time but just can't seem to get it. Any help would be appreciated. Thank you, -- Dewayne From: ozgrid.com on 30 Apr 2010 20:28 If(D3=0,0,IF(E15/D45=J30,E15/D45,"Error")) -- Regards Dave Hawley www.ozgrid.com "Dewayne" wrote in message news:341024DA-BB62-4E6D-8F29-CE3304EBE586(a)microsoft.com...> This is what I need to accomplish in H15: > > IF D30=0,0 > IF E15/D45 = J30 return the value of E15/D45 > otherwise "Error" > > I've been playing with this for some time but just can't seem to get it. > Any help would be appreciated. > Thank you, > -- > Dewayne From: Dewayne on 30 Apr 2010 21:41 Thank you Dave -- Dewayne "ozgrid.com" wrote: > If(D3=0,0,IF(E15/D45=J30,E15/D45,"Error")) > > > -- > Regards > Dave Hawley > www.ozgrid.com > "Dewayne" wrote in message > news:341024DA-BB62-4E6D-8F29-CE3304EBE586(a)microsoft.com... > > This is what I need to accomplish in H15: > > > > IF D30=0,0 > > IF E15/D45 = J30 return the value of E15/D45 > > otherwise "Error" > > > > I've been playing with this for some time but just can't seem to get it. > > Any help would be appreciated. > > Thank you, > > -- > > Dewayne > From: Steve Dunn on 4 May 2010 09:55 Another option: =IF(D30,IF(E15/D45=J30,J30,"Error"),0) "Dewayne" wrote in message news:341024DA-BB62-4E6D-8F29-CE3304EBE586(a)microsoft.com...> This is what I need to accomplish in H15: > > IF D30=0,0 > IF E15/D45 = J30 return the value of E15/D45 > otherwise "Error" > > I've been playing with this for some time but just can't seem to get it. > Any help would be appreciated. > Thank you, > -- > Dewayne  |  Pages: 1 Prev: Logical Test for blank and then for scoreNext: Excel and consecutive number