"AND" query

[avinashraste]

Dear friends,

I have a formula, working fine but I don't know how to extend the query...!!! The query is in cell N8 :

If L8 = "Buy"
(M8-P8)+M8
Else
M8-(ABS(P8-M8))

This works fine. But I want to extend it with the addition to the first formula : If K8 = "", N8 = ""


Please guide & help

Thanks in advance

AR

 

[jproffer]

Try this:

=IF(K8="","",IF(L8="Buy",(M8-P8)+M8,M8-(ABS(P8-M8))))

 

[philwojo]

What do you mean by extend? Do you want to make sure that L8="Buy" and both K8 and N8 are "", or do you mean something else?

 

[avinashraste]

Try this:

=IF(K8="","",IF(L8="Buy",(M8-P8)+M8,M8-(ABS(P8-M8))))

Dear jproffer,

Thanks a million. You have solved my problem. Fantastic & perfect solution.

Thank you once again for all your time & help.

Regards
AR

 

[avinashraste]

What do you mean by extend? Do you want to make sure that L8="Buy" and both K8 and N8 are "", or do you mean something else?

Dear philwojo

The problem is solved. The solution suggested by jproffer worked perfectly fine.
But many thanks to you also for replying the post.

Regards,
AR

 

[philwojo]

Dear jproffer,

Thanks a million. You have solved my problem. Fantastic & perfect solution.

Thank you once again for all your time & help.

Regards
AR

I'm not saying this isn't working for you, but I don't see this testing for N8 at all, as long as you are OK with that and it works for you great, but just wanted to point that out as you indicated in your original post (OP) that you wanted to test if N8="" as well.