If and if/and statement

cpontiff
cpontiff ✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to do an if statement for if a cell is blank to leave it blank and if not to perform an if/and statement. I did it in Excel but when I imported the file into Smartsheet it wasn’t working. So I’m trying to write it in Smartsheet. 

I did get it to work at one point but the acceptable and review responses were backwards. Now I continue to get errors when I’m trying to fix it .

i want if my ratio is below 100% and the increase is more than 5% to return “acceptable”, if not to return “review” and if the increase amount if blank to return a blank cell.

 

If(increase=“”,””,if((and(ratio<.1,increase>.5),”acceptable”,”review”)

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!