Cannot seem to get this formula to work properly

Hi There,

I am having trouble getting this formula to work properly. I think i have it right but i keep getting a false return and it is not giving me the response i need for multiple cells.

In the Example.

I need Column F to say what is in row C, only if what is in column A is populated and it

so something like this:

In column F, i need something like: If column C is less than 0 but Column A is populated return the value in Column C in F, but if Column C isles than 0 and column A is not populated return blank or 0, If column C is greater than zero and column A IS populated return value in Column C, but if Column C is greater than 0 and Column A IS NOT populated than return 0 or blank.

The problem is the subtotals are getting populated when i don't need them

Hopefully this makes sense, i have tried 100 ways from sunday but can't get both results in one formula,

I think this is what you are after :

=IF(AND(C2>0, ISBLANK(A2)),0,C2)

It's the and function that is the secret you were missing.

How would you deal with C2 if it was positive?? and still didn't want it to return the value in C2?? as i have positive subtotals too

Are you just trying to do this?

EXAMPLE.xlsx

Perhaps this might clear things up.

Please see attachment

C<0, a >0 = c
c<0, a="" = 0
c>0, a>0 = a
c>0, a="" = 0

Sorry, FDibbins, am i missing something?? did you forget to add something? sorry bit of a newb