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

 

 

Resources