Is it possible to write an If function within a sub??

I am pulling data from one workbook and inputting it into a second, and returning calculations from the seond to the first workbook. I was wondering is it possible to write and If funtion within my sub, so that when a cell I pull from the first workbook goes below a certain value it automatically inputs a certain number

Please Login or Register  to view this content.

Want something like this however this does not work

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

Try this

Please Login or Register  to view this content.

Am glad it worked.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save