IF Statement

[kenadams378]

I have the following IF statement;

Please Login or Register  to view this content.

How can i add the following into this formula;

In cell DN If cell DM2 is blank then check cell BL is blank then check cell Q2 equals "Margin" if correct then populate DN with N/A - Margin Fund

can i just add an &IF at the end of the above code??

[dluhut]

Just use the regular IF statement

Please Login or Register  to view this content.

[kenadams378]

Thank you for the reply, the formula doesn't seem to work, if i exclude all the code and just leave;

IF(AND(DM2="", BL2="", Q2="Margin"), "N/A - Margin Fund", "Incomplete Formula")))

then this works but i need it to work alongside the full formulae?

Any ideas?

[:) Sixthsense :)]

Please describe your requirement clearly with expected output for better understanding...

[kenadams378]

I currently have the following formula that using reference data to pull in depending on the criteria;

Please Login or Register  to view this content.

I need to add to this a formula that will in cell DN2

- check cell DM2 is blank then
- check cell BL2 is blank then
- check cell Q2 equals "Margin"
- if correct then populate DN2 with N/A - Margin Fund
- if incorrect then leave blank

[:) Sixthsense :)]

May be this...

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[kenadams378]

Brilliant.

You are a star, thankyou

Thanks to dluhut too

[Shustarful]

Sorry to disturb, can anyone please help on calculating overall mean/mean of mean if one can say.

Thank you in advance

[ChemistB]

Hi Shustarful
You need to start a new thread with a new topic.