Hello…I am new.
I need some help to do something…
1/I have a column B, with a currency field.
2/I have a column C, with % field.
3/I havr a column D, of number.
4/I have a column E, of % field.
5/I have a columm F, of currency.
I need percentage of column C and E automatically.
So if :
Column B has a total of $100.
IF I insert 10% into Column C.
The column D should show me 90$.
but IF i need to changes into Column D from 90 to 95$.
then the column C shows me 5%.
reflect both sides if i changed any value from column C and D.
after that… Successive Discounts applied on column E.
I insert 2% into colum E.
Then column F will show me 88.2 (2% of 90 column D price)
and the final price show me on column F.
if changes into D it reflects to C, if changes into Fit reflects to E.
I don’t know how to create a formula which will calculate the discounted amount based on the price.
I would be great to have some help on that!