Set up formula to update when new column data is entered

How can I set up a formula to update when new column totals are added? Is
this even possible? Here is an example;

Current formula shows: =IF(J4>I4,"Up Prev Mth", "Under Prev Mth") this
compares the data from J4 with I4.

What I want it to do is update to: =IF(K4>J4,"Up Prev Mth", "Under Prev
Mth") when it detects data has been entered into K4.

This may require programming at which I am really not qualified. Any help or
suggestions to eliminate the manual updates would be appreciated. Thanks, Jim.

Possibly modify your formula and prefill your cells

for example, in the cell that would refer to K4

=If(K4="","",IF(K4>J4,"Up Prev Mth", "Under Prev Mth"))

--
Regards,
Tom Ogilvy

"Bushman" wrote:

> How can I set up a formula to update when new column totals are added? Is
> this even possible? Here is an example;
>
> Current formula shows: =IF(J4>I4,"Up Prev Mth", "Under Prev Mth") this
> compares the data from J4 with I4.
>
> What I want it to do is update to: =IF(K4>J4,"Up Prev Mth", "Under Prev
> Mth") when it detects data has been entered into K4.
>
> This may require programming at which I am really not qualified. Any help or
> suggestions to eliminate the manual updates would be appreciated. Thanks, Jim.