IFS Statement

[Hanvey]

Formulas and Functions

I have an IFS statement that I want to return a blank value if there is no data in the referenced cell.

IF G2 is blank then the value the formula provides in O2 should be blank as well.  I can't get this to happen as it is returning the first value in the statement.  I have tried putting an ISBLANK statement in the front and back of the formula, as well as using the ="".  Where am I going wrong? Below formula works for every value indicated.  I just need the piece to return a blank cell if none of these are met.

=IFS(G2<10000,"$0 to $9,999",G2<15000,"$10,000 to $14,999",G2<20000,"$15,000 to $19,999",G2<30000,"$20,000 to $29,999",G2<50000,"$30000 to $49,999",G2<100000,"$50,000 to $99,999",TRUE,"$100,000 and Greater")

[#2]

@Hanvey 

Add this as your first test within the IFS:

G2="",""

so that it becomes like this:

=IFS(G2="","",G2<10000,"$0 to $9,999",G2<15000,"$10,000 to $14,999",G2<20000,"$15,000 to $19,999",G2<30000,"$20,000 to $29,999",G2<50000,"$30000 to $49,999",G2<100000,"$50,000 to $99,999",TRUE,"$100,000 and Greater")

[#3]

@Riny_van_Eekelen 

Thank you! You indirectly resolved my issue!!!  Stupid mistake on my part.  While I have tried this in the past and it did not work, I copied and pasted the information into a different cell and discovered the issue.  I had previously set the column up with Data Validation and changed the way I was looking at the data later.  Doing this I had apparently not cleared out the validation and therefore the formula was not working as it should.  Problem resolved!