Try this,

=IF(A3="HR",IF(OR(ISBLANK(D3),D3=0),IF(OR(ISBLANK( H3),H3=0),I3,H3),D3),"")


Steve



"ZOEY" wrote in message
...

I have been trying to get a formula to work for the following:

Cell A3 Cell D3 Cell H3 Cell I3 Cell K3
HR 0.00 0.00 -10.00 (answer in this
example -10.00)

I need a formula in Cell K3 that would do the following; If A3=HR, then
enter value in D3 unless blank or zero, then enter value from H3 unless
blank or zero, then enter value from I3.

I can get it to work if I only have 2 cells for it to look. How can I
get it to consider 3 different cells? There will only be one of the
three cells with a value.

Thanks Zoey


--
ZOEY
------------------------------------------------------------------------
ZOEY's Profile:
http://www.excelforum.com/member.php...o&userid=32616
View this thread: http://www.excelforum.com/showthread...hreadid=524100