Inserting a calculation based on percentage to affect results of a cell

[G Wiz]

I have the below data and when the percent amount is changed this needs to alter the Resistance figure which is derived from formula of the thickness and conductivity. See formula from the Resistance column:

=IF(E10<>"",C10/(1000*E10),"")

E10 is the Conductivity value
C10 is the Thickness

Now I just need to make the resistance alter accordingly if the Percentage is altered.

So in this case the Resistance at 100% is 0.17, the Resistance at 50% would be 0.085.

Can anyone help me insert the necessary formulae into the current formula: =IF(E10<>"",C10/(1000*E10),"")

Layer	Thickness	Percentage	Conductivity	Resistance
(mm)	(mm)	(%)	(W/mK)	(m2K/W)
				​
Timber, larch	20​	100.0%​	0.120​	0.17​

 

[Fluff]

How about

=IF(E10<>"",C10/(1000*E10)*D10,"")

 

[G Wiz]

Great, thanks!

 

[Fluff]

You're welcome & thanks for the feedback.