[Millsy250777]

Hello

I am trying to multiply two cells together. Easy enough you would think but I am struggling....

First Cell: Cell I3
This contains a £ amount which has been created by a formula H3/G3

Second cell: Cell P3
This contains a % amount which has been created by =SUM(L3-D3)/D3

I3 value is £180.44
P3 value is 3.3%
I want the result to of this calculation to end up in Z3 and to read £186.39

What formula do I use?! I have 300 rows that need this formula so help would be much appreciated!!

Thanks

 

[etaf]

what value is in cell P3 is it 3.3 or is it 0.033 and formatted as %

if P3 is 3.3
then
=I3*(1+(P3/100))
or if its 0.033
then
=I3*(1+P3)

 

[Millsy250777]

Thank you it worked! Brilliant