Cell Formula
I have a range of cells that will cotain an "X" i need a formula in a cell to
recognise if these cells contain an "X" and return a value of £0.50 and so on
if another X is placed in the range of cells this will increase to £1.00 and
so on, I know this is easy I had it last week but cant remember it.
Thanks,
Mark
|