how to use the same cell with IF() function

P

persian_boi

function im using is IF()

my function reads =IF(B7=C3,C7+5,C7)

now when select the cell with this IF() function and drag it over all
the cells under it, i want it so that this is what happens to the
function

=IF(B8=C3,C8+5,C8)
=IF(B9=C3,C9+5,C9)
=IF(B10=C3,C10+5,C10)

insteadddd what i get is

=IF(B8=C4,C8+5,C8)
=IF(B9=C5,C9+5,C9)
=IF(B10=C6,C10+5,C10)

how do i keep the C3 in the function from changing? do i need to put
some symbol near it?


thanks!
:)
 

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

Top