How to make cell return blank

[Raggedyman]

Hello - The follow formula =if(G2<$M$5,"1", if(G2<$M$6,"2",if(G2>+$M$7,"3"))) works as I need it to. I would like to add another parameter within the same formula that if G2 is empty to return "Blank"

Thanks in advance,

 

[jasonb75]

Try

=IF(G2="","",IF(G2<$M$5,1,IF(G2<$M$6,2,IF(G2>$M$7,3))))

Note also that I removed the double quotes from "1","2" and "3". Numbers in double quotes are a bad idea, they might work now but often cause problems later.

 

[Raggedyman]

Jason - It Works! Thanks!!