L
Legacy 69493
Guest
Thanks for your help in creating an IF statement but now I would like to change the column numbers automatically and have the formula in every column.
ie. =If(O32="G",N32*0.06,"")
then I want this to change to
=IF(O33="G",N33*0.06,"")
Is there a way of having the column numbers change automatically in every column so that I don't have to enter this to over 200 columns?
Thanks
ie. =If(O32="G",N32*0.06,"")
then I want this to change to
=IF(O33="G",N33*0.06,"")
Is there a way of having the column numbers change automatically in every column so that I don't have to enter this to over 200 columns?
Thanks