Two part formula - only progress if criteria one is met

[AdamPriest]

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,

Adam

 

[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.

=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.

=IF(B12<$B$3;0;E12*$C$7)

 

[eduzs]

Maybe?

=IF(B12<$B$3,0,(E12*$C$7))