Lookup populated cell before an empty one??

  • Thread starter Thread starter Elsmith
  • Start date Start date
E

Elsmith

A B C
1000 3500 200

My query is about excel picking up the right cell based
on population. So IF C is populated use C, IF C is NOT
populated and B is use B but if B is also not populated
use A.

I don’t know if a function that uses the cell that is
populated and furthest to the right will work IE: If A B &
C were populated it would use C but if only A was
populated it would use A??

Or if there is a function that picks up a number before a balnk cell??
 
Back
Top