Automatically Entering Values
 

Is there any way to preset some values?
Suppose I entered some values in From A1 to A4 (A1=12,A2=13,A3=14,A=15)
Now I want that when I enter 12 in C1, it automatically feels 13 in C2,14 in
C3,15 in C4.
Is that possible?How?

Automatically Entering Values
 

You can have hidden formulas in so in cell C2 you can put

=IF(Len($C$1)0,$C1+1,"")

This will check if anything is in C1 if so then do the formula... if not the
cell is blank

"Sanchit" wrote:

Is there any way to preset some values?
Suppose I entered some values in From A1 to A4 (A1=12,A2=13,A3=14,A=15)
Now I want that when I enter 12 in C1, it automatically feels 13 in C2,14 in
C3,15 in C4.
Is that possible?How?

Automatically Entering Values
 

akphidelt,
I'm interested. Why do you use a LEN function in this formula? I know
what LEN does, I just assume you are avoiding some issue by doing it
this way instead of a simple "$C$10". Why is that?

Automatically Entering Values
 

akphidelt,
I'm interested. Why do you use a LEN function in this formula? I know
what LEN does, I just assume you are avoiding some issue by doing it
this way instead of a simple "$C$10". Why is that?

I'm not akphidelt, but did notice that the original post did not specify
that the entered values must be positive numbers. Using the LEN function
(instead of "$C$10") permits entered values to be positive or negative or
zero. If that's not the intent, change the formula accordingly.

Automatically Entering Values
 

On Aug 26, 4:35 pm, "pomegranate-man"
wrote:
akphidelt,
I'm interested. Why do you use a LEN function in this formula? I know
what LEN does, I just assume you are avoiding some issue by doing it
this way instead of a simple "$C$10". Why is that?

I'm not akphidelt, but did notice that the original post did not specify
that the entered values must be positive numbers. Using the LEN function
(instead of "$C$10") permits entered values to be positive or negative or
zero. If that's not the intent, change the formula accordingly.

Thanks!