Not sure what you are looking for...

In any cell enter (in the same row, as most likely it will point to a range)
=Billing_Amount
assuming Billing_Amount is the name given to 'billing amount'

"zen" wrote:

I have to enter various figures of work load volume and hourly rates in
various worksheets, at the end I have to run the macro to calculate the
billing amount. The cell which gives me the billing amount is named & I dont
see any formula written there, can I just see the value in formula bar?
Problem is that the one who developed this file had left & secondly our
nature of business is changing, we just want to see how billing amount is
worked out. Any help will be appreciated.