If formula

[sgkb]

Hi,

I used to be a Lotus guru years ago but Excel has me beat.

This is what I am trying to do which used to be so easy in Lotus.

If B48<0, goto C48, otherwise put the value in $E$28 into cell B43,
If C48<0, goto D48, otherwise put the value in $E$28 into cell C43,
If D48<0, goto E48, otherwise put the value in $E$28 into cell D43, etc

Any help much appreciated !!

Regards,
Stuart

[TMS]

Maybe:

Cell B43: =IF(B48<0,$E$28,"")

And drag across.

Regards, TMS

[sgkb]

Many thanks - will give it a try right now.

[ExcelIsEasy]

Hi there! Here you have IF Function tutorial. I hope it helps.