Highlighted
New Contributor

# IFS Statement

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 Replies
Highlighted

# Re: IFS Statement

``````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")``````

Highlighted

# Re: IFS Statement

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!