Prevent deleting functions

J

JKeef

I have a document set up with IF statements to auto populate redundant
information. For example: the customer bill to address and the customer ship
to address. If the information is different they can type over my function-
but then it is gone. Is there a way to keep the function there without doing
save as each time?
 
N

Niek Otten

Use another cell for input. In the cell where it should be, enter a formula like

=IF(A2="",A1,A2)

With addresses in A1 and A2.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a document set up with IF statements to auto populate redundant
| information. For example: the customer bill to address and the customer ship
| to address. If the information is different they can type over my function-
| but then it is gone. Is there a way to keep the function there without doing
| save as each time?
 
J

JKeef

That is how my statements are set up, they auto populate from the customer
bill to address into the customer site address- but if the address is
different, they type in the same box over my function. In your scenario below
it would be A2.

Is there a way to enter for example cell c2 enter formula:
=IF(a2<>"",b2=a2,"") this way the actual cell for input (being b2) has no
formula to type over.
 
N

Niek Otten

What I meant is: If you print your data from C1 and C2, let the user input it in A1 and A2. In C1, use this formula:

=A1

In C2, use this formula:

=IF(A2="",A1,A2)


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| That is how my statements are set up, they auto populate from the customer
| bill to address into the customer site address- but if the address is
| different, they type in the same box over my function. In your scenario below
| it would be A2.
|
| Is there a way to enter for example cell c2 enter formula:
| =IF(a2<>"",b2=a2,"") this way the actual cell for input (being b2) has no
| formula to type over.
|
| "Niek Otten" wrote:
|
| > Use another cell for input. In the cell where it should be, enter a formula like
| >
| > =IF(A2="",A1,A2)
| >
| > With addresses in A1 and A2.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have a document set up with IF statements to auto populate redundant
| > | information. For example: the customer bill to address and the customer ship
| > | to address. If the information is different they can type over my function-
| > | but then it is gone. Is there a way to keep the function there without doing
| > | save as each time?
| >
| >
| >
 
J

JKeef

I understand, but the user is entering the information once, maybe twice.
Is there a way to place the results of an IF statement in another cell?
Type in cell z1=If(A2<>"",c2=a2,c2="") Maybe an IF THEN statement?
 
G

Gord Dibben

A formula cannot send a value to another cell.

Formulas "pull", they don't "push".


Gord Dibben MS Excel MVP
 
Top