What does "tota" return in a formula i.e. =IF(D23>0,D23+totb,0)
M Max Apr 3, 2008 #2 Eric H said: What does "tota" return in a formula i.e. =IF(D23>0,D23+totb,0) Click to expand... 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
Eric H said: What does "tota" return in a formula i.e. =IF(D23>0,D23+totb,0) Click to expand... 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
M Max Apr 3, 2008 #4 How does one name ranges? Via Insert>Name>Define (the main way) or, via using the namebox
