IF/AND question

[Nickster64]

I am having trouble making a code for this to put into a macro I am working on...

Starting on Row 3...IF there is a value in a column B cell AND there is a value in a column D cell (same row), THEN use the following formula in column F: "=B cell - D cell", OR leave blank if not true.

I know this is an easy one but I can't figure it out!

Thanks

[NBVC]

This would be a formula for that for cells in Row 3

=IF(AND(B3<>"",D3<>""),B3-D3,"")

[Nickster64]

Thanks NBVC, this worked well but it gives me a blank if for example cell B4 = a blank, and cell D4 = 1000. In this case I would want my result in cell F4 to = -1000.

I am going to take the final formula and apply it to my entire column F because over time my list is going to grow larger.

[Nickster64]

I also noticed that the formula would return a blank if cell B4 = 1000 and cell D4 = 0 instead of cell F4 = 1000.

[arthurbr]

Well, you stated that BOTH B3 and D3 should not be blanks to perform the operation .
If you want F4 to be -1000 replace AND with OR ( depending on your conditions)

[NBVC]

Then you want OR()

=IF(OR(B3<>"",D3<>""),B3-D3,"")

[Nickster64]

Yes OR did the trick, thank you.

[NBVC]

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