I have created a named varible called race6first
which I can input in result!$B$28.
I would like to refer to this named varible
in a formula created by varying the numeric 6 or any numeric no. Example: race6first is being input as 10 in a formulacell f32
=”race”&trim(a32)&first*17
if
“race”&trim(a32)&first returns 10
then
f32=170
endif
my question ???
how to make “race”&trim(a32)&first return 10 ?????
instead of the textstring race6first
