Can anyone help me with this statement.

If A1 is equal to or less than 100 then divide by 5.

If A1 is equal to or greater than 101 then subtract 100

This will do it:


=IF(A1<=100,A1/5,A1-100)



"jsayssimon" wrote:

> Can anyone help me with this statement.
> 
> If A1 is equal to or less than 100 then divide by 5.
> 
> If A1 is equal to or greater than 101 then subtract 100

=IF(A1<=100,A1/5,IF(A1>=101,A1/100,"A1 is between 100 and 101 so answer is 
undefined"))
--
David Biddulph


"jsayssimon" <jsayssimon@discussions.microsoft.com> wrote in message 
news:BCA0FF0D-9DCC-4691-A305-52904BC57836@microsoft.com...
> Can anyone help me with this statement.
>
> If A1 is equal to or less than 100 then divide by 5.
>
> If A1 is equal to or greater than 101 then subtract 100