| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
G4 is =C4+D4+E4 , what each one value is?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
G4 is =C4+D4+E4 , what each one value is?
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
G4 is =C4+D4+E4 , what each one value is?
Even better:
ToolsFormula AuditingEvaluate Formula -- Kind regards, Niek Otten Microsoft MVP - Excel "Dan" wrote in message ... | 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
