software

I am trying to get one cell to look at 2 others, determine which one has a
value, and use that value. for example, d3 has no value, d4 has a value of
2.333. how do i get d5 to look at the 2 cells and give me 2.333. Also,
sometimes d3 will have value and d4 won't. only one will have a value at any
given time. hope that is not too confusing.

thanks for the help.

Sounds like a simple If statement. Type the following into the cell where
you want the value to appear:

=if(d3gt;0,d3,d4)

Assuming that d4 will always have a value if D3 doesn't.

Good luck!

quot;The-Jayhawk_fanquot; wrote:

gt; I am trying to get one cell to look at 2 others, determine which one has a
gt; value, and use that value. for example, d3 has no value, d4 has a value of
gt; 2.333. how do i get d5 to look at the 2 cells and give me 2.333. Also,
gt; sometimes d3 will have value and d4 won't. only one will have a value at any
gt; given time. hope that is not too confusing.
gt;
gt; thanks for the help.

=IF(D3lt;gt;0,D3,D4)
Regards,
Alan.
quot;The-Jayhawk_fanquot; gt; wrote in
message ...
gt;I am trying to get one cell to look at 2 others, determine which one has a
gt; value, and use that value. for example, d3 has no value, d4 has a value
gt; of
gt; 2.333. how do i get d5 to look at the 2 cells and give me 2.333. Also,
gt; sometimes d3 will have value and d4 won't. only one will have a value at
gt; any
gt; given time. hope that is not too confusing.
gt;
gt; thanks for the help.
Alan's is better as it allows for negative #s.

Along that line, if you want to allow for 0 to be a valid answer go with:
=if(d3lt;gt;quot;quot;,d3,d4)

quot;The-Jayhawk_fanquot; wrote:

gt; I am trying to get one cell to look at 2 others, determine which one has a
gt; value, and use that value. for example, d3 has no value, d4 has a value of
gt; 2.333. how do i get d5 to look at the 2 cells and give me 2.333. Also,
gt; sometimes d3 will have value and d4 won't. only one will have a value at any
gt; given time. hope that is not too confusing.
gt;
gt; thanks for the help.

=max(cell1,cell2)
,allows for your value to be either positive, nil or negative.

MIN function would also work.

quot;The-Jayhawk_fanquot; wrote:

gt; I am trying to get one cell to look at 2 others, determine which one has a
gt; value, and use that value. for example, d3 has no value, d4 has a value of
gt; 2.333. how do i get d5 to look at the 2 cells and give me 2.333. Also,
gt; sometimes d3 will have value and d4 won't. only one will have a value at any
gt; given time. hope that is not too confusing.
gt;
gt; thanks for the help.