Excel help needed (again!)

Factual Questions
1

It is for the tire price calculating sheet. My suppliers have a fixed discount on tires, about 25%. This is the value in the M column. But once a month, there are some special offers on selected tire sizes, usually an extra 5%. Is there any way to have a separate column for those special offers (eg. column P) and modify the formula so that if column P is empty the formula uses the regular discount from column M. But if P has a value it uses that instead of M?

Is this possible/easy to do? Or am I better off by editing the M column directly?

2

I think the basic structure you are looking for is:

=IF(ISBLANK(P1),M1,P1)

where P1 is the special discount and M1 is the ordinary discount.

Without looking at your linked thread in too much detail, I would say that the easiest way would be to put this formula in a new column, fill down, and refer to that new column in any discount calculations.

3

I might be missing something, but it seems to me that the easiest way to do this is to have a ‘standard discount’ column and an ‘extra discount’ column. Say Tire Y is 30% off this week; you put 5% in the extra discount column and then multiply the original price by ‘standard discount’ + ‘extra discount’. For cases with no extra discount, you simply put zero in the ‘extra discount’ column.

4

Thanks for the answers! :smiley:

I have already done this two-column thingie for another calculation so I would like to avoid doing it again. The sheet is too cluttered as it is. I think QuizCustodet’s solution is a bit simpler.
Now I have a new question: I want to have on a different column the wholesale price of tires, but somehow disguised. If for example the price is 250,00 euros, I would like it to look like a code number such as A00250. The wholesale price is stored on column R

5

Just use something like the RIGHT function. In column A you may have BR250 or BZ1001 so in column B put =RIGHT(A1,LEN(A1)-2)

6

which uses all but the first 2 caharacters of the cell.

7

don’t ask, I want to do the opposite. I have the wholesale price and I want to disguise it :slight_smile:

I managed to do it by right-clicking and Format Cells and choosing Custom. I 've put something like A00000 which, if the wholesale price is 250 euros gives A00250. Now the problem is that the cells do not transfer correctly to Access. They transfer as numbers.