ExcelBanter - IF Function Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function Help (https://www.excelbanter.com/excel-worksheet-functions/262899-if-function-help.html)

Dewayne

IF Function Help

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

ozgrid.com

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

Dewayne

IF Function Help

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
...
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

Steve Dunn

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

All times are GMT +1. The time now is 06:34 PM.