add condition to 'INDIRECT formula

J

Jeff McCann

I use the following formula to get A:1, A:2, A:3, etc.,
values placed in B:600, B:603, B:606, etc. (which allows
blank spaces for B601.B602, B604.B605, etc.:

=INDIRECT("A"&(ROW(3:3/3))

"then click F5 => 'special' => uncheck all
except 'constants'=> 'enter'=>'delete.'

Can you suggest how this same format can be accomplished
with use of a conditional, e.g., value for B:600 is A:1 if
A:1=x, (if not, 0); value B:603 =A:2 if A:2=x; etc.?

Your help is very much appreciated.

Jeff McCann
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top