Set up formula to update when new column data is entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing Dates in 4 Columns - Nested Formulas? 2
Data Move 1
Need some VBA help 11
Code to insert functions not working anymore 2
VB code to update existing Pivot Table 2
How to Determine if column of certain rows in a text file has data? 1
Help with my VBA and formula 8
Subtotal and IF Formula 1

Back
Top