Lil help please

[duffntx68]

Not sure if this a hard task or not, but I looked through the forum and didnt see anything like what I am looking for. I am trying to find a formula that will simply put a 1 in the next column when I type anything in the box beside the input box. Like if I type anything into 1A, 1B will read 1, and of course if 1A is empty 1B will also be empty. Thanks in advance if anyone can help me out.

 

[Aladin Akyurek]

Not sure if this a hard task or not, but I looked through the forum and didnt see anything like what I am looking for. I am trying to find a formula that will simply put a 1 in the next column when I type anything in the box beside the input box. Like if I type anything into 1A, 1B will read 1, and of course if 1A is empty 1B will also be empty. Thanks in advance if anyone can help me out.

Something like...

B1:

=IF(A1="","",1)

 

[T. Valko]

Not sure if this a hard task or not, but I looked through the forum and didnt see anything like what I am looking for. I am trying to find a formula that will simply put a 1 in the next column when I type anything in the box beside the input box. Like if I type anything into 1A, 1B will read 1, and of course if 1A is empty 1B will also be empty. Thanks in advance if anyone can help me out.

Try this formula in B1:

=IF(A1="","",1)

 

[Rick Rothstein]

This will also work, but my first inclination is to use the IF method that other's have posted...

=LEFT(1,A1<>"")

 

[duffntx68]

Tried the first 2 but couldnt get em to work, Thanks Rick yours worked like a charm!!!! Thanks for your time though

 

[Rick Rothstein]

You are welcome; however, I do not see why the IF versions that were posted are not working for you. Are you sure you used exactly what the others posted? You should try them again as they are the more natural way to write what you asked for.

 

[duffntx68]

OK went back and retried and the others worked better for me, they auto calculated and the one that originally worked wouldnt auto calculate. Thanks again all