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