<div>
Thanks,<br />
<br />
Do you know if there is any way to do this without code?<br />
<br />
WTC
</div>


Thanks,

Do you know if there is any way to do this without code?

WTC

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im trying to make my custom units variable depending upon a value in a cell.<br />
<br />
for example if cell A1 contains &quot;W&quot; (Watts) cells A2:A5 have &quot;W&quot; as their units. If A1 has &quot;mW&quot; or &quot;kW&quot; then A2:A5 should have units &quot;mW&quot; or &quot;kW&quot; respectively.<br />
<br />
thanks!
</div>
</div>


Hi,

Im trying to make my custom units variable depending upon a value in a cell.

for example if cell A1 contains "W" (Watts) cells A2:A5 have "W" as their units. If A1 has "mW" or "kW" then A2:A5 should have units "mW" or "kW" respectively.

thanks!

MS Excel Custom Units

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.