Hey, quick question

**Sundeep** · 06-13-2006, 10:29 AM

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.

Oh also, one more question, if have one column which i put in just Y or N , is there a way if that field has Y in it, it would automatically highlight the row from a certain cell to another cell in that row?

Dave Peterson · 06-13-2006, 10:55 AM

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.

Sundeep wrote:
>
> 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.
>
> --
> Sundeep
> ------------------------------------------------------------------------
> Sundeep's Profile: http://www.excelforum.com/member.php...o&userid=35110
> View this thread: http://www.excelforum.com/showthread...hreadid=551447

--

Dave Peterson

Bondi · 06-13-2006, 11:00 AM

Sundeep wrote:
> 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.
>
>
> --
> Sundeep
> ------------------------------------------------------------------------
> Sundeep's Profile: http://www.excelforum.com/member.php...o&userid=35110
> View this thread: http://www.excelforum.com/showthread...hreadid=551447

Hi Sundeep

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

Will lock AA294

Regards,
Bondi

Bob Phillips · 06-13-2006, 11:10 AM

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

and copy down

--

HTH

Bob Phillips

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

"Sundeep" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Sundeep
> ------------------------------------------------------------------------
> Sundeep's Profile:
http://www.excelforum.com/member.php...o&userid=35110
> View this thread: http://www.excelforum.com/showthread...hreadid=551447
>