SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Excel Function?

(3 posts)
  • Started 5 years ago by coates719
  • Latest reply from coates719
  • Topic Viewed 1241 times

coates719
coates719
Posts: 102

I know that if i type in this formula =A1+$B$1 into C1 and drag it down everything in column A will always be added to B1 not B2, B3, B4 etc.

Even though I Know this works by typing in the dollar signs I don't know what function creates the dollar signs.

Does anyone know?

Thanks in advance.

Posted 5 years ago
Top
 
Aleeve
Aleeve
Posts: 2818

Lookup tables!

Can't really tell you much about them I'm afraid

but that's what it is :)

Posted 5 years ago
Top
 
coates719
coates719
Posts: 102

Cheers, I'll give it a go.

Posted 5 years ago
Top
 



Topic Closed

This topic has been closed to new replies.

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!