Hey, quick question

[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

 

[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.

 

[Bondi]

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.

Hi Sundeep

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

Will lock AA294

Regards,
Bondi

 

[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)