Tech Support Guy banner
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
277 Posts
Discussion Starter · #1 ·
Hi,

I am trying to call two methods in the formula, and map it together

I.e

=(CheckSize(1) +" "+ CheckSize(2)) .. but it is displaying #VALUE! in the cell..

Is there a different way to map two variables.. ?

Thankyou
 

·
Registered
Joined
·
5,458 Posts
Hi there,

Thanks for posting your solution! One little tip though: be careful when titling your threads and try to make the titles very meaningful, so you may have used something like, "Combine data in Excel", or "Put Excel cell values together", something like that. A lot of people will only skim the forum thread/topics and if it is something meaningful, they'll stop by and look, some people will not even look if the title is not very descriptive.

I am also curious though, what is CheckSize()? Is that a UDF you have?

Also, you can mark your thread as Solved by going to Thread Tools | Mark Solved | Perform Action.
 

·
Registered
Joined
·
5,458 Posts
You know, I may be stepping out onto a limb here, but if you sometimes have multiple values you want to return, you could use a ParramArray variable in your UDF, so you would only have to call the routine once, i.e. ...

=CheckSize(1,2)

If you're interested in this, post your UDF code. :)
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top