General Question

[mtaystl11]

I was wondering if it is possible to make a certain cell change value if
any number is inserted in A DIFFERENT cell.

Example. I have a dollar value for one cell (A1), 10 cells over I have
a place to enter what that actual price was (A10). Could I get the
dollar value cell to display $0 after I put the actual price.

Again, If I put a numeral in A10 can A1 automatically change to "$0"
even if there is a forumla already in A1?

Thanks a million!

 

[Ragdyer]

What is the formula that is already in A1?

 

[mtaystl11]

=((P230/C3)*C4)+(P230/C3)*C5+((P230/C3)*adjust!C6)

 

[Ragdyer]

Try this:

=OR(A10={"",0})*(((P230/C3)*C4)+(P230/C3)*C5+((P230/C3)*adjust!C6))

 

[Roger Govier]

Hi RD

Or maybe simplified to

=OR(A10={"",0})*(P230/C3)*(C4+C5+adjust!C6)

 

[RagDyeR]

Never really looked at the OP's formula, just pasted it in, BUT ... you're
right,
nice concise revision!
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Hi RD

Or maybe simplified to

=OR(A10={"",0})*(P230/C3)*(C4+C5+adjust!C6)