AdamPriest
New Member
- Joined
- Oct 28, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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
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