Hi,
I am trying to copy and paste a formula down but when I go down two lines in my the calc sheet I need the formula to go just one line down on the workings tab
example
In cell M6=IF(LM!F5<0,LM!E5,LM!D5).
In M7 and M8, I have a few calculations
When I past the formula from M6 in M9, I need =IF(LM!F6<0,LM!E6,LM!D6)
However, Excel brings =IF(LM!F8<0,LM!E8,LM!D8)
Any ideas?
Best Regards,
Josvill
Bookmarks