How to form this question???

[dustyj357]

here is what I am looking for:



a3=[(a1/-11)/a2] if a1<0

[Pecoflyer]

Hi
not quite sure what you want to achieve?
What happens when A1>=0 ?

[dustyj357]

When that is the case, I would like the cell to either be blank or just remain at 0 if possible

[Pecoflyer]

Try =IF(A1<0,((a1/-11)/a2),0)

[dustyj357]

That was it. Thank you so much. After hours of playing with it I was just ,0 away from having it myself. I have been out of the excel loop for a few years. I am quite rusty. Thanks again.

[Pecoflyer]

You're most welcome