Help with IF (again)

I have 4 columns

Base Data; Better than Base; Even better Data; The Best Data: TOTAL

In the TOTAL column I need to insert info - if the only data is Base then Base, if the data is Better than Base then Better, if the data is Even Better then Even Better, if The Best then The Best.


ie

Base Data; Better than Base; Even better Data; The Best Data: TOTAL
75,000..............................................................................75,000
79,000................................80,000.....................................80,000
30,000.........................................................26,000............26,000


Thanks

This works, but only if there is data to the immediate LEFT. If I have Base Data then The Best - It only gives me Base Data.
ie if there are any blanks if ignores what is RIGHT of the blank!

We have Base Data - as time progresses we get Better Data (moving left to right) however, this sometimes jumps a review and can go from Base Data to The Best Data. If that makes sense!

Thanks