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 |
Cell Formula
=countif(A1:C10,"x")*.50
and format the cell to display £ and two decimals. -- Regards, Tom Ogilvy "santaviga" wrote: 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 |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com