New User: fiwel

Engineering student. Ended up here looking for Excel help.

What your problem in Excel?

I have several equations that I need to look better.

If say: A1=1 A2=2 A3=3 A4=4

Instead of "=A1*A2+A3*A4" I would want it to say "1*2+3*4". I tried the Formatted Excel Equations on this site that was rather perfect, except it also just keeps to the cell name: A1*A2+A3*A4.

Any ideas?

Basically you want the values rendered rather than the actual equations. That is an interesting twist on our system.

I'll look into developing that. I can't see any technical problems.

Yes, exactly what I want. It would be perfect for the task I'm on at the moment! After battling with Excel for what seems like a very long time, this made me quite positive again.

Developing something like that, any idea how long it would take? Hours, days or weeks would be sufficient :)

Hi,

I'll have to say weeks, but I might crack it in days! I've made a start this evening, but I've a lot of work over the next two weeks. The real challenge (in fact the only challenge) is running through an equation and identifying all the cell references like B4, C7 etc, and then retrieving the values for each of these, and dropping them into the equation.

One immediate question, what rounding should we apply to floating point values, i.e. if B4=3.14169265358979, what should be entered into the equation?

I am content with B4=3.142 on the project I'm on at the moment. I usually use 3 when doing the calculations, then round it to two at the end of it all.