View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Dunn Steve Dunn is offline
external usenet poster
 
Posts: 193
Default IF Function Help

Another option:

=IF(D30,IF(E15/D45=J30,J30,"Error"),0)


"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