View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default IF Function Help

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