here is what I am looking for:



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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

You're most welcome

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post