Forum Discussion
Formula help
Hi, I have a list of sales in a column and another column that shows if a sale has been cancelled, in this column there are only 2 options Blank and Cancelled. When I choose cancelled I want the ...
Here is a simple IF formula that makes it possible.
=IF(B2="Cancelled","0",B2)
Also attached is an example file.
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
NikolinoDE Thank you but not quite right My sheeet looks like this.
- Please more details, in which cell is Sales Value?
only see the amount (I don't know whether this is called a sales value or a deposit).
Remember that the same cell with value entry and formula is not possible, if ... then with other options such as VBA code.
Please provide step-by-step information for your project.- Thanks for the reply. The column with Dollar valye is the sales column the other column is blank with a drop down box where the only option is "cancelled". What I was wanting to do, was that upon choosing CANCELLED the coresponding sales value will turn to 0, This is so that the running total will reflect the fact that this sale is no longer happening and therefore sales total needs to be reduced.
Thanks again
