IF Function help

[Jetstar77]

Hi Guys

I am looking to create a formula for 2 columns. The formula will check if the first column has a value greater than 1 and if the answer is yes it will then execute the formula =A1-B1 and show the answer. if the result is less than 1 then it will be blank.

Any help you can give me would be much appreciated.

Thanks

[Pete_UK]

Try this:

=IF(A1<1,"",A1-B1)

Hope this helps.

Pete

[Jetstar77]

Awesome Pete I think this is what I am after!!!

[Pete_UK]

We all had to start somewhere …

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

[Jetstar77]

Yup I will be doing that, just waiting for confirmation from the Boss that this solved the issue we were having! The response time was phenomenal!