Subscribe to How-To Geek

Welcome to the How-To Geek Forums

We encourage you to register on our forums and post any questions you might have. The How-To Geeks monitor this forum and will respond to your question quickly.

How-To Geek Forums » Microsoft Office

Excel Function?

(3 posts)
  • Started 2 months ago by coates719
  • Latest reply from coates719
  • Topic Viewed 139 times


coates719
coates719
Posts: 101

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 2 months ago #
 
Aleeve
Aleeve
Posts: 1594

Lookup tables!

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

but that's what it is :)

Posted 2 months ago #
 
coates719
coates719
Posts: 101

Cheers, I'll give it a go.

Posted 2 months ago #
 

RSS feed for this topic

Reply

You must log in to post.

Sponsored Links
Getting Started
About How-To Geek
What Is That Process?
svchost.exe
jusched.exe
dwm.exe
ctfmon.exe
wmpnetwk.exe
wmpnscfg.exe
rundll32.exe
wfcrun32.exe
Ipoint.exe
Itype.exe
Wfica32.exe
Mobsync.exe
Cmd.exe
Dpupdchk.exe Adobe_Updater.exe

Copyright © 2006-2008 HowToGeek.com. All Rights Reserved.