Charting a mathematical equation using Excel and defined names

Sample Equations

I'd like to invite the readers to provide nice sample equations!

Contact me when you have found some nice examples to add here.

A sample file can be downloaded here.

Comments

Showing last 8 comments of 26 in total (Show All Comments):

Comment by: Jan Karel Pieterse (3/7/2011 6:29:00 AM)

Hi,

I think the best way to find that out is by trying!

Comment by: Alan Forster (3/7/2011 9:06:41 AM)

Hello,

I did try, but it did not work. I wondered if there was another little trick like adding the + 0*x.

Evaluate is a poorly documented feature and I have struggled to learn much about it. As I type I wonder if it requires the function to be volatile? I will give it a go and report back if it works.

Thanks,

Alan.

Comment by: Jan Karel Pieterse (3/7/2011 10:41:15 AM)

Hi Alan,

OK. I guess you should make the UDF volatile.
I'm interested to learn your result!

Comment by: Alex Young (7/5/2011 6:13:19 AM)

Hi Jan,

How complex can the formula be? I have a situation with plenty of logic arguments, IF & ANDs - I can make it work using two IFs but any more than that and it fails. Its a long formula but it is correct, I've substituted the x for a value and calculated it and it comes up with the correct answer.

Any help you can offer would be appreciated,

Thanks,

Alex

Comment by: Jan Karel Pieterse (7/5/2011 6:37:12 AM)

Hi Alex,

I don't really know, maybe the formula cannot be longer than about 250 characters?

Comment by: Alex Young (7/5/2011 6:52:17 AM)

Thanks for the prompt reply, my longest formula has 216 characters...

Is there any way to introduce other variables through the EVALUATE function? Or otherwise split up long formulas? I have worked out basic addition/subtraction already.

Regards,

Alex

Comment by: Jan Karel Pieterse (7/6/2011 4:44:18 AM)

Can you perhaps post the formula?

Comment by: Laertes Boechat (11/28/2011 4:08:58 AM)

Certain things do not come into existence by trial and error alone. The method of using the scattered chart for plotting an equation is already very creative.
Thanks for the tip. Great idea.

Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.