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??
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??