Please help with formula

[mrl]

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

 

[Bernie Deitrick]

mrl,

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.

In cell F5, enter

=IF(AND($J$17<=$K$17,D5<>""),0,IF(AND($J$17>=$K$17,D5<>""),????5,""))

replace the ???? with the column letter of the value that should be returned.... your words indicate
column F, but that is the column with the formula, so that doesn't make sense. Also, you stated
"<=" and ">=" --- you should use <= and > , or < and >= but not both, since = is a
specific case and your conditonals are indeterminate at that point.

Then copy cell F5 down to F6:F14.....

HTH,
Bernie
MS Excel MVP

 

[mrl]

It worked great. FYI it looks at Column E (not F) typo on my part, so
sorry. I am so very grateful. I've been trying this for two days. Thank
you Bernie! I'm a little bit smarter now. Marilyn