Excel: Nested If with blank..

[Xlacs]

Hello Good People,

Just wanted to seek assistance regarding the below formula.

Whenever the cell J2 is blank it returns a Value of 1.
What I wanted to, is whenever J2 is blank, it will return the value as Blank..

Hoping someone could help me on this =(

=IF(J2<2.51,"1", IF(J2<3,"2",IF(J2<3.51,"3")))

 

[johnnyL]

How about:
=IF(J2="","",IF(J2<2.51,"1",IF(J2<3,"2",IF(J2<3.51,"3"))))

 

[rlv01]

In addition to what @johnnyL posted, what do you want the formula to return if J2 is greater than or equal to 3.51?

 

[Xlacs]

How about:
=IF(J2="","",IF(J2<2.51,"1",IF(J2<3,"2",IF(J2<3.51,"3"))))

Wow, simple as that.. Thank you..

Now all the cells returned blank if J2 is blank..

Just a quick follow up question.

=sum(P2:R2)
=N2*45%

If they are also blank, it returns #value.

How do return it if blank? =/

 

[Xlacs]

please ignore.. I figured it out. THank you Guys

 

[johnnyL]

Glad to help.