Formulas

[AngelaEI]

Hi,

I have columns G and H showing list price , in H and I ,i want to show prices with 63 % discount off G and H , can someone show me how to do this formula?
Many thanks

Angela

[#2]

@AngelaEI 

For example in I2:

=G2*(100%-63%)

Fill to the right to J2, then fill down (or vice versa)