ExcelBanter - What is this formula for?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What is this formula for? (https://www.excelbanter.com/excel-worksheet-functions/146699-what-formula.html)

yaheegunsome

What is this formula for?

Can someone explain this formula to me?
=$C$36/$B$6

Rick Rothstein $MVP - VB$

What is this formula for?

Can someone explain this formula to me?
=$C$36/$B$6

The dollar signs represent absolute references; so the formula is dividing
whatever is in cell C36 by whatever is in cell B6... and will always do
that, no matter where you copy the formula to.

Rick

All times are GMT +1. The time now is 11:13 PM.