Declare New inline named variables in a cell

[nagkumar]

Is it possible to declare special cell context variable for this


=(ROUND((((F14/$E$34)*100)/F3)*$E$30,0)) & " ($" & ROUND((ROUND((((F14/$E$34)*100)/F3)*$E$30,0))/$E$29, 0)& ")"

as (ROUND((((F14/$E$34)*100)/F3)*$E$30,0)) is repeated two times, is possible to define as variable and refer to it

[sintek]

Something like this...

Please Login or Register  to view this content.

Please Login or Register  to view this content.