# Two part formula - only progress if criteria one is met

##### New Member
Hi,

Sorry if this is a really simple question, but I'm struggling to get my head around a solution.

I'm looking to set up two criteria within a single formula, with the 2nd part of the formula being dependent on the criteria being met in the first part.

This is my table.

The formula in cell F12 is currently =(E12*\$C\$7) i.e number of sales x cost per unit. I'd really like to add a caveat before this to say that if the figure in B12 is lower than the figure in B3 then return a value of £0. if it's greater than it can continue to work out the rest of the formula.

Is that possible?

Thanks,

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### Joe4

The formula in cell F12 is currently =(E12*\$C\$7) i.e number of sales x cost per unit. I'd really like to add a caveat before this to say that if the figure in B12 is lower than the figure in B3 then return a value of £0. if it's greater than it can continue to work out the rest of the formula.
Try just as you say, using an IF function, i.e.
Excel Formula:
``=IF(B12<\$B\$3,0,E12*\$C\$7)``

Note: Depending on your version of Excel, you may need to use semi-colons instead of commas for your argument separators, i.e.
Excel Formula:
``=IF(B12<\$B\$3;0;E12*\$C\$7)``

#### eduzs

##### Well-known Member
Maybe?
Excel Formula:
``=IF(B12<\$B\$3,0,(E12*\$C\$7))``

Replies
4
Views
210
Replies
6
Views
274
Replies
1
Views
95
Replies
7
Views
178
Replies
3
Views
226

1,127,348
Messages
5,624,145
Members
416,014
Latest member
MickP69

### 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