Copying a Formula from NotePad to Excel

  • Thread starter Thread starter carl
  • Start date Start date
C

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.
 
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.
 
paste it into a temporary worksheet in the cell that you wrote the formula for.

then copy|paste that cell to your final location.
 
Oops. Didn't see your reply.

Frank said:
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.
Click to expand...
 
Back
Top