Forum Discussion

Hanvey's avatar
Hanvey
Copper Contributor
Apr 21, 2020

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 bla...
office 365
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 21, 2020

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

 

 

  • Hanvey's avatar
    Hanvey
    Copper Contributor
    Apr 21, 2020

    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!  

Resources