putting a number equal to writing commands

M

martin

Hello!

How can i put a certain number to write as many "x"-s (for instance) to a
certain number of places.
For more clarity, pleasee see http://www.hot.ee/rekor/excerc.xls

If i write 5 to cell A3, what is the function that this number 5 will write
"x" to 5 certain cells: c3, e3, g3, i3, and k3.

Thanks:)
 
J

Jason Morin

Place this in A3, copy across as far as needed, then copy
down:

=IF(AND(COUNTIF($B3:B3,"x")<$A3,MOD(COLUMN(),2)=1),"x","")

HTH
Jason
Atlanta, GA
 
J

JulieD

Hi Martin

can't see what is wrong - if you'ld like to email me direct i'll send you a
worksheet with the formula in it then we can see how that works on your
system. My email address is julied_ng at hcts dot net dot au.

Cheers
JulieD
 

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

Similar Threads

Attendance formula for payroll please help 0
if function 1
if function 3
Total Working hours If 2
Is there a specific Excel Function that doesn't this? 4
Setting a cell with a value as a reference for another function 1
Number of IF statements exceeded... 7
Adding and subtracting time 2

Top