View lables in formula

[Bob]

How do I see the labels assigned to cells in the formula bar rather than
the cell designation?

i.e. I want to see: =('Number of units' * "cost per unit') rather than
=(E59*E60)

Thanks Bob

 

[Bob]

I have found that the above question refers to using "natural Language"
in the PC versions. Is this available in the Mac X version?

Bob

 

[Bob]

Thanks

-----Original Message-----
Go to Tools>>Options on the menu bar, select
the 'Calculations' tab and check 'Accept labels in
formulas' check box under 'workbook options'. You should
then be able to type your formula in as :-

=Number_of_Units * Cost_per_Unit

HTH


.