Formula Help.

[CCHolden]

Hi,

I'm having a hard time getting a formula to work, and hoping someone here can point me in the right direction. Below is part of the sheet I'm working with.

If for example column A is 10, I need the cell with the formula to be populated with £2.07. I've tried many variations of greater and lower than formulas, but nothings working.

Sorry for the lack of detail in the title, I have no idea what this problem might be called.

Thank you in advance!

 

[CCHolden]

No, I still need the 0 I think as there's lots of rows that this criteria doesn't apply to and will come back to 0.00

 

[Fluff]

Then I don't understand what your asking.

 

[CCHolden]

No worries, Thank you for your help with the first problem, you saved me loads of time.

 

[Fluff]

You're welcome & thanks for the feedback.