Help Please - 2003 IF

[kjoy064]

Howdy,

i need a little help if possible. I'm trying to sort that if a cell (Q22) contains text (anything) that cell it adds cell R22 into AC22. But also if S22 has text that it adds Q22 (only if T22 has text) all into AC22 and so on up to 6 if's.

Below is what i have thus far.

=IF(R22<>"",Q22,IF(T22<>"",S22,+IF(V22<>"",U22,IF(X22<>"",W22,IF(Z22<>"",Y22,IF(AB22<>"",AA22,0))))))

thanks

 

[Weaver]

Is there any way you could illustrate your data set and expected results? It may make the problem a little clearer.