Copying a Formula from NotePad to Excel

[carl]

I have a formula on my notepad and would like to copy it
to excel. the column refernces are correct but the row
reference are not.

is there a way to copy and have excel apply the formula to
the row that I place the formula in ??

Here's the formula.

=IF(AND(C5<=3,B5="Buy",A5="Cancel"),E5+0.15,IF(AND
(C5<=3,B5="Sell",A5="Cancel"),D5-0.15,IF(AND
(C5>3,B5="Buy",A5="Cancel"),E5+0.3,IF(AND
(C5>3,B5="Sell",A5="Cancel"),D5-0.3))))

Thank You in Advance.

 

[Frank Kabel]

Hi Carl
without changing the formula no way. You'll have to change the first
formula on your own.
As a workaround: copy this formula in row 5 and then copy it in Excel
from row 5 to your desired row.

 

[Dave Peterson]

paste it into a temporary worksheet in the cell that you wrote the formula for.

then copy|paste that cell to your final location.

 

[Dave Peterson]

Oops. Didn't see your reply.

Hi Carl
without changing the formula no way. You'll have to change the first
formula on your own.
As a workaround: copy this formula in row 5 and then copy it in Excel
from row 5 to your desired row.

 

[Frank Kabel]

Oops. Didn't see your reply.

Hi Dave
no problem
Frank