I have 4 columns A,B,C,and D
the value will appear in only one column at a time
I want to report that value in column D
Have no difficulty with only 2 columns ie =IF(A6>0,A6,IF(B6>0,B6))...Returns value or blank cell in D
Or =IF(A6>0,A6,IF(B6>0,B6,0))...Returns value or 0 in D
When I attempt to add Column C, always get the message "To many arguments"
How do I link several IF arguments?
Bookmarks