G4 is =C4+D4+E4 , what each one value is?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

there is some way to evaluate the component of a formula by clicking f9 or
something.
Not by using the formula editing button.
I just cannot remember what it is.

I would need to know what C4 D4 and E4 values are by clicking on G4

Any idea?
Many thanks
 
Even better:

Tools>Formula Auditing>Evaluate Formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Ok I found it - just need to highlight the portion of the formula and do an F9
|
| "Dan" wrote:
|
| > there is some way to evaluate the component of a formula by clicking f9 or
| > something.
| > Not by using the formula editing button.
| > I just cannot remember what it is.
| >
| > I would need to know what C4 D4 and E4 values are by clicking on G4
| >
| > Any idea?
| > Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too many IF functions 3
Multiplication problem- Please Help! 8
Hide Cell Information 5
Don't understand PMT(d412,e4,-c4) what is it asking me or means? 1
Need help with range value calculation 5
How do I ignore blank cells while averaging the solutions of equat 2
Chart to display only bars for values that are > 3 & blank cells 1
HELP! Nesting IF Statements/Dependent Dropdown List 4

Back
Top