IF And Statement not wokring

[Star1566]

Hello I am having an issue with my formulas in excel. I have created conditions based on what is entered into column J, if these conditions are not met then the cells should display N/A. Right now they (cells J26 and J27) are displaying the actual value even when there is a blank. The formulas are in column K cells 26 and 27.

I have attached the file link for reference, thanks in advance for your help!

https://drive.google.com/open?id=1YUEoeP9CzNQa3X5Hdjeq3ZqW9ynxSJZY

 

[Fluff]

Try
=IF(J26="","",IF(J26<15,"A",IF(J26<31,"B",IF(J26<46,"C",IF(J26<60,"D","F")))))

 

[jtakw]

Hi,

As Fluff has shown, you don't need all the ANDs, here's another way:

=IF(J26<>"",IF(J26>=60,"F",IF(J26>=46,"D",IF(J26>=31,"C",IF(J26>=15,"B","A")))),"N/A")

 

[Star1566]

Thank you!

 

[Star1566]

Awesome thanks!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[jtakw]

You're welcome, glad to help.