Hey, quick question

S

Sundeep

Hey guys, I am at work, I have a quick question for yall.

How do I paste this =IF(V4="SMS",(AJ4*AA294),"") while onl
incrementing the V4 by 1 and AJ4 by 1, so the next cell would be ...

=IF(V5="SMS",(AJ5*AA294),"") , I keep trying to copy and paste, an
excel automatically increases the AA294 =( .. thanks for the help i
advance
 
D

Dave Peterson

Use
$AA$294

And neither the column (AA) nor the row (294) will change.

You may want to look up "About cell and range references" in excel's help.
 
B

Bondi

Sundeep said:
Hey guys, I am at work, I have a quick question for yall.

How do I paste this =IF(V4="SMS",(AJ4*AA294),"") while only
incrementing the V4 by 1 and AJ4 by 1, so the next cell would be ...

=IF(V5="SMS",(AJ5*AA294),"") , I keep trying to copy and paste, and
excel automatically increases the AA294 =( .. thanks for the help in
advance.
Click to expand...

Hi Sundeep

=IF(V4="SMS",(AJ4*$AA$294),"")

Will lock AA294

Regards,
Bondi
 
B

Bob Phillips

=IF(V4="SMS",(AJ4*AA$294),"")

and copy down

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top