# Formula

#### VbaHell

##### Well-known Member
Hello One and all

Excel 2007

What is the best way please to complete a formula for this

If a1 >0 and b1 = "Open" then D1-A1 (if not show a blank cell)

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Try

=IF(AND(A1>0,B="Open"),D1-A1,"")

Works a treat

Thank You

Replies
4
Views
93
Replies
1
Views
79
Replies
1
Views
138
Replies
4
Views
354
Replies
9
Views
163

1,203,727
Messages
6,056,970
Members
444,899
Latest member
Excel_Temp

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back