=IF(J23<=84.9%,"$0.00",IF(,J23>=85%<=88.9%,"$500.00","0.0")) thank you
C cowgirl New Member Feb 14, 2019 #1 =IF(J23<=84.9%,"$0.00",IF(,J23>=85%<=88.9%,"$500.00","0.0")) thank you
R rahulshewale1 Active Member Feb 14, 2019 #2 Hii @cowgirl, see if is ok? =IF(A1<=84.9%,"$0.00",IF(A1<=88.9%,"$500.00","0.0"))
C cowgirl New Member Feb 14, 2019 #3 got it to work thank you Last edited by a moderator: Feb 14, 2019