View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The-Jayhawk_fan
 
Posts: n/a
Default look between 2 cells and give the value of only 1

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.