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