software

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: www.excelforum.com/member.php...oamp;userid=32616
View this thread: www.excelforum.com/showthread...hreadid=524100One solution would be to nest your quot;ifsquot; .
I didn't test this but it's close to what it sounds like you want. Not sure
if the test for text will work.

if(A3lt;gt;0,(if(D3=0,I3,D3),quot;quot;)

Or this way.
=IF(A1lt;gt;0,MAX(B1,C1,D1),quot;nonequot;)

quot;gt; I have been trying to get a formula to work for the following:
gt;
gt; Cell A3 Cell D3 Cell H3 Cell I3 Cell K3
gt; HR 0.00 0.00 -10.00 (answer in this
gt; example -10.00)
gt;
gt; I need a formula in Cell K3 that would do the following; If A3=HR, then
gt; enter value in D3 unless blank or zero, then enter value from H3 unless
gt; blank or zero, then enter value from I3.
gt;
gt; I can get it to work if I only have 2 cells for it to look. How can I
gt; get it to consider 3 different cells? There will only be one of the
gt; three cells with a value.
gt;
gt; Thanks Zoey
gt;
gt;
gt; --
gt; ZOEY
gt; ------------------------------------------------------------------------
gt; ZOEY's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32616
gt; View this thread: www.excelforum.com/showthread...hreadid=524100
gt;

If only one of the cells can have a value just sum them

=IF(A3=quot;HRquot;,SUM(D3,H3:I3),quot;quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=524100Try this,

=IF(A3=quot;HRquot;,IF(OR(ISBLANK(D3),D3=0),IF(OR(ISBLANK( H3),H3=0),I3,H3),D3),quot;quot;)Steve
quot;ZOEYquot; gt; wrote in message
...
gt;
gt; I have been trying to get a formula to work for the following:
gt;
gt; Cell A3 Cell D3 Cell H3 Cell I3 Cell K3
gt; HR 0.00 0.00 -10.00 (answer in this
gt; example -10.00)
gt;
gt; I need a formula in Cell K3 that would do the following; If A3=HR, then
gt; enter value in D3 unless blank or zero, then enter value from H3 unless
gt; blank or zero, then enter value from I3.
gt;
gt; I can get it to work if I only have 2 cells for it to look. How can I
gt; get it to consider 3 different cells? There will only be one of the
gt; three cells with a value.
gt;
gt; Thanks Zoey
gt;
gt;
gt; --
gt; ZOEY
gt; ------------------------------------------------------------------------
gt; ZOEY's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32616
gt; View this thread: www.excelforum.com/showthread...hreadid=524100
gt;
The example showed numerical values in D3, H3 and I3 but what if one or more
of the values is text that can't be interpreted as a number value?
quot;daddylonglegsquot; gt;
wrote in message
news:daddylonglegs.24xyuo_1142813401.0826@excelfor um-nospam.com...
gt;
gt; If only one of the cells can have a value just sum them
gt;
gt; =IF(A3=quot;HRquot;,SUM(D3,H3:I3),quot;quot;)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=524100
gt;

Hi Steve,

Of course you're right. I'm assuming the cells will either be blank or
numeric...., perhaps I shouldn't be....--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=524100Thank you ALL for the replies!! DaddyLongLegs... It worked! The 3
cells will only have numeric.

Zoey--
ZOEY
------------------------------------------------------------------------
ZOEY's Profile: www.excelforum.com/member.php...oamp;userid=32616
View this thread: www.excelforum.com/showthread...hreadid=524100