Nested If formula

Hollie Green

I'm sure I'm missing something simple but I keep getting an unparsable for this formula and it shouldn't be. It should be a 4

=IF([Tickets % on Time]@row <=75%, 1, IF([Tickets % on Time]@row <=79.9%, 2, IF([Tickets % on Time]@row <=85%, 3, If([Tickets % on Time]@row <=92%,4, 5))))

The number in the Tickets% on Time row is 89.2%

Carson Penticuff

You have to "decimalitize" your percentages… give this a try:

=IF([Tickets % on Time]@row <=0.75, 1, IF([Tickets % on Time]@row <=0.799, 2, IF([Tickets % on Time]@row <=0.85, 3, If([Tickets % on Time]@row <=0.92, 4, 5))))

Jennifer Kurtz

Hi @Hollie Green !

Is your [Tickets % on Time] column entered as a number, and then formatted to display as a % — for example, 75% is really entered as 0.75?

If so, you'll just need to change how you've typed the numbers in your formula to be decimals: e.g., .75, .85 etc.

(If that column is entered as literally "75%", then i think you could enclose those values in quotation marks in your formula.)

Does that work?

Carson Penticuff

You have to "decimalitize" your percentages… give this a try:

=IF([Tickets % on Time]@row <=0.75, 1, IF([Tickets % on Time]@row <=0.799, 2, IF([Tickets % on Time]@row <=0.85, 3, If([Tickets % on Time]@row <=0.92, 4, 5))))

Jennifer Kurtz

Hi @Hollie Green !

Is your [Tickets % on Time] column entered as a number, and then formatted to display as a % — for example, 75% is really entered as 0.75?

If so, you'll just need to change how you've typed the numbers in your formula to be decimals: e.g., .75, .85 etc.

(If that column is entered as literally "75%", then i think you could enclose those values in quotation marks in your formula.)

Does that work?