If-Then Function... again

  • Thread starter Thread starter janthony
  • Start date Start date
J

janthony

Alright -

So far I have found excellent help from this site and for that
would like to thank all of you that take the time to answer pett
questions like the ones I constantly have.

My new task at hand is this: I have included a link to the data
am trying to work with. If you feel this will give you a better idea o
what I'm attempting to accomplish please take a look at the image.

[image: http://img66.photobucket.com/albums/v200/civilant/if-then2.jpg


I am having problems with the syntax that will allow me to do thes
things with the data in the photo:

1. Subtract Column K from Column J

2. If the returned value is smaller than the original Column J value
then I need that returned value to show up in Column L. (As you can se
I have manually done the math just to give you guys a better idea o
what I'm talking about)

3. If the returned value doesn't change in the original Column
(meaning Column K has a value of 0 therefore Column J isn't changed)
need Column L to be left blank/empty (also as I have shown in th
picture).

My database holds 16,000 rows and I find that touch cumbersome to do
at a time!

Please Advise!!!;
 
Back
Top