Formula based on percentage range

maltaee

Hello,

I have the following score grid

25%-49% of Action Plan completed

50%-74% of Action Plan completed

75%-89% of Action Plan completed

≥ 90% of Action Plan completed

I created the formula =IF([Column5]@row) = 25%-49%, "Zero", If([Column5]@row = 50%-74%, Check Minus, if([Column5]@row = 75%-89%, Check, Check Plus)

I wasn't sure how the formula will recognize the percentage range.

Thanks,

Darren Mullen

@maltaee You'll have to use the AND() function

=IF(and([Column5]@row >= .25, [Column5]@row <= .49), "Zero", ....... create addition if with AND in the condition)

Darren Mullen

@maltaee You'll have to use the AND() function

=IF(and([Column5]@row >= .25, [Column5]@row <= .49), "Zero", ....... create addition if with AND in the condition)