Been a long time since I've done this, but I know it can be done....I have my take home pay in a cell (b3)....I want to put the formula in each cell for what % of my income that expense is.....

so I put =(b8/b3) and that works for that cell....how can I just insert that formula changing the b8 to whatever cell it is automatically?

relative cell? I'm a bit confused but know this is easy to do...