I thought as much, just had to ask. Thanks

--

Regards
Michael Koerner


"Jim Thomlinson" <jamest@tcgiRe-Move-This.com> wrote in message
news:D9E0462F-065A-4D4F-97F1-48CA56ED96EC@microsoft.com...
> Nope. A formula in one cell can only affect itself. It can not put values
> into other cells. In the grander scheme of things you wouldn't want it to,
> because if it could you would never be able to debug a problem in one cell
> because you would never be able to determine what other cells might have
> put
> a value into it.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Michael Koerner" wrote:
>
>> In A2 I have the following formula =IF(R2="","",R2).
>> In B2 the following =IF(S2="","",S2),
>> and in C2 the following =IF(T2="","",T2)
>>
>> Is there a formula that I could use in A2 that would allow me to put the
>> values from R2, S2, and T2 into A2, B2, and C2 without having to have
>> additional formula in B2 and C2?
>> --
>>
>> Regards
>> Michael Koerner
>>
>>
>>
>>