Format cell as %:

=IF(A1<0,1,IF(A1<0.0999,0.98,IF(A1<0.1499,0.97,??) ))

and if x = 0.1499 ????

The above satisfies:

If Cell X is less than 0, then 100%
If Cell X is less than 0.10, then 98%
If Cell X is greater less than 0.1499, then 97%

HTH


"Teri" wrote:

Can somebody PLEASE help me write this as an IF statement?

If Cell X is less than 0, then 100%
If Cell X is greater than 0, but less than .0999, then 98%
If Cell X is greater than .10, but less than .1499, then 97%

I'm going nuts!!!