Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tot
What does "tota" return in a formula i.e. =IF(D230,D23+totb,0)
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|