I have 13 rows in Column D that are populated with a formula that looks at
F31. Formula returns a null value if criteria are not met, returns proper
value if criteria is met. that is working fine. I did not know how to
manipulate that formula to do this next step. I have tried and tried.

I need 13 rows in Column F to look at and do two different things. First,
I need rows F5 thru F14 to return a value after comparing J17 to K17; IF <=
it must be zero, but only if corresponding row in Column D is populated.
Otherwise, I need it to not show at all (null?) IF = return value in cell
in Column F. Each row in F will have different value I will assign in
Formula. But again, only if same row in D has a value. If a different row
has a value, it needs to populate that row (cell) in Column F. e.g.if D5 has
a value, F5 will have a 0 or value, and F6 thru F14 will now show a value.

I truly hope this explains what I hope someone can help me with... Marilyn

--
The generosity of your knowledge is greatly appreciated.