Thread: Excel Formula
View Single Post
Old 07-05-2008, 19:04   #5
davidoc
cf.member
 
Join Date: Jun 2006
Posts: 39
davidoc is an unknown quantity at this point
Re: Excel Formula

This one also works.....

=IF(Q3=1,J2,IF(Q4=1,K2,IF(Q5=1,L2,IF(Q6=1,M2,IF(Q7 =1,N2,IF(Q8=1,O2,""))))))
__________________
Don't ask me....I know nothing..
davidoc is offline   Reply With Quote