Return Rightmost Value in Range

Hi all,

Trying to write an 'IF' formula but struggling - any help appreciated

I have a spreadsheet where there is sometimes data in Q6, W6, Z6, AF6. However I only ever want the data further to the right. So for instance, if something is in AF6, then show it. If not, then show what is in Z6. If not then show what is in W6. if not then show what is in Q6.

Not quite sure if 'IF' is the right way to go on this because only got as far as "If AF6<>"",Z6"

Any help appreciated