Forum Discussion
Excell Discount Formula
I have a workbook with 20 sheets or so and they are all estimate sheets and I am looking to apply a discount in the sheet based on manufacturer code in column B and have is apply discounts in column ...
If the result is there and you can't see it, it is probably a formatting issue.
Can you site what is in R36?
Can you site what is in R36?
If B36 = FUL and R36 is empty then the cell where you put this formula will be a zero (0).
If B36=FUL and one (1) is entered in R36, the number in the cell where you entered the formula
is = 0.714285714
Attached the file.
Hope I was able to help you with this info.