If(D3=0,0,IF(E15/D45=J30,E15/D45,"Error"))
--
Regards
Dave Hawley
www.ozgrid.com
"Dewayne" wrote in message
...
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