Report data from one cell in a string of cells

[LValencia]

What I have is 5 cells in a row that may or may not have data. What I want is, if one or more cells have data I only want a particular cells data this would be the primary cell. This data would be collected in another cell in the sheet.
Example:
P1 20, Q1 0, R1 50, S1 10, T1 5. R1s data will always be used unless it is zero, then it would be P1s data. The formula would be in cell F1.
thanks for your help
tried several formulas but cant seem to get there.

 

[gaz_chops]

Maybe

=if(R1=0,P1,R1)

 

[jmacleary]

Welcome to the board. In cell F1 try:

=if(R1=0,P1,R1)

 

[gaz_chops]

Or maybe, having read it again

=IF(COUNTA(P1:T1),IF(R1=0,P1,R1),"")

 

[LValencia]

ADVERTISEMENT

Worked great exactly what I needed. For my info what is counta and what is it asking excel to do?

 

[gaz_chops]

You're welcome, counta checks if any cells in the range have a value, if they do then returns P1 or R1, if no values then returns blank.

 

[LValencia]

ADVERTISEMENT

Great thanks, one other question can I step it down, if P1 doesnt have value report S1, if no value then T1. Tried adding to formula but got error, no expert here learning from the board how to improve my formulas.

 

[gaz_chops]

Try

I haven't tested this

=IF(COUNTA(P1:T1),IF(R1<>0,R1,IF(P1<>0,P1,IF(Q1<>0,Q1,IF(S1<>0,S1,T1)))),"")

 

[LValencia]

Worked great thank you for your time and expertise.
Merry Christmas and happy new year.
Go Saints (south hampton)

 

[gaz_chops]

You're welcome.

And Merry Xmas & Happy New Year to you too.