Help needed to correct the formula

[excel_sp]

Hi,

I am sure, that I am missing something silly which is stopping me from getting the desired result. This formula is a small part of a project that I am working on. Can someone please look at the screenshot, and tell me what I am doing wrong?

Condition:
If C3 = NA and D3 ="" then E3 should be 5
But on excel, my outcome is 10

The

Screenshot Link: https://drive.google.com/file/d/1yONG2cKat5JPot5eehLnmm4oQKYgRGN0/view?usp=sharing

 

[Sam_D_Ben]

My be you can try this. My version is 2013.

=IF(C3="NA",IF(D3="NA",10,IF(ISBLANK(D3),5,IF(D3<=2.5%,10,IF(D3>2.5%,5)))))

 

[excel_sp]

Thank you Sam, it worked. Let me implement this on my actual project. I will share an update soon.

 

[Sam_D_Ben]

You are welcome.