| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
putting a number equal to writing commands
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:) |
|
#2
|
|||
|
|||
|
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 -----Original Message----- 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:) . |
|
#3
|
|||
|
|||
|
Hi Jason
it works better if it's put in C3 rather than A3:) Cheers JulieD "Jason Morin" wrote in message ... 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 -----Original Message----- 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:) . |
|
#4
|
|||
|
|||
|
Doh! Did I write A3? Thanks Julie.
Jason -----Original Message----- Hi Jason it works better if it's put in C3 rather than A3:) Cheers JulieD "Jason Morin" wrote in message ... 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 -----Original Message----- 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:) . . |
|
#5
|
|||
|
|||
|
I should have written "Place this in C3". Sorry.
Jason -----Original Message----- 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 -----Original Message----- 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:) . . |
|
#6
|
|||
|
|||
|
I'm sorry, it gives me a false message
http://www.hot.ee/rekor/hmm.GIF "JulieD" wrote: Hi Jason it works better if it's put in C3 rather than A3:) Cheers JulieD "Jason Morin" wrote in message ... 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 -----Original Message----- 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:) . |
|
#7
|
|||
|
|||
|
I'm sorry, but I still haven't got it right.
It gives me the same error message as i wrote before. http://www.hot.ee/rekor/hmm.GIF Please help! "Jason Morin" wrote: I should have written "Place this in C3". Sorry. Jason -----Original Message----- 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 -----Original Message----- 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:) . . |
|
#8
|
|||
|
|||
|
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 "martin" wrote in message ... I'm sorry, but I still haven't got it right. It gives me the same error message as i wrote before. http://www.hot.ee/rekor/hmm.GIF Please help! "Jason Morin" wrote: I should have written "Place this in C3". Sorry. Jason -----Original Message----- 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 -----Original Message----- 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:) . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Which numbers in a column equal a certain number (withou. | Excel Worksheet Functions | |||
| How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
