If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|