tot

  • Thread starter Thread starter Eric H
  • Start date Start date
Eric H said:
What does "tota" return in a formula i.e. =IF(D23>0,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

---
 
How does one name ranges?

Via Insert>Name>Define (the main way)
or, via using the namebox
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More than one IF Statement 5
Missing blanks 11
Greater than 4
Bringing Formatting with the If state 2
Excel formula 5
CountIF 11
Sumifs, averageifs, countifs 6
Formula Use 8

Back
Top