Forum Discussion
Solved
Excel formula Help
Hi, I am trying to create a formula which looks at a value in a cell then depending on the value returns a set price. for example if cell a1 is between 0 and 0.03 it should return the value of £1...
Hi,
If ignore your "etc." the function could be like
You may hardcode your ranges within the formula, but that's not a good idea.
Same is in attached file.
Hi,
If ignore your "etc." the function could be like
You may hardcode your ranges within the formula, but that's not a good idea.
Same is in attached file.
hi sergei,
that works great, thanks a lot
that works great, thanks a lot