ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - tot (https://www.excelbanter.com/excel-discussion-misc-queries/182363-tot.html)

eric H

tot

What does "tota" return in a formula i.e. =IF(D230,D23+totb,0)

Max

tot

"Eric H" wrote:
What does "tota" return in a formula i.e. =IF(D230,D23+totb,0)

Suspect totb, etc are named ranges
In a new sheet, select say A1,
then click Insert Name Paste Paste List
The mystery behind totb will probably be unravelled
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Eric H

tot

Mystery revealed! thanks...
How does on name ranges?

"Max" wrote:

"Eric H" wrote:
What does "tota" return in a formula i.e. =IF(D230,D23+totb,0)

Suspect totb, etc are named ranges
In a new sheet, select say A1,
then click Insert Name Paste Paste List
The mystery behind totb will probably be unravelled
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

tot

How does one name ranges?

Via InsertNameDefine (the main way)
or, via using the namebox
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric H" wrote in message
...
Mystery revealed! thanks...
How does on name ranges?

All times are GMT +1. The time now is 06:04 AM.