From: Jacob Skaria on
=A1-(A1*IF(A1<=50,10%,IF(A1<=100,20%,IF(A1<=500,30%))))

--
Jacob


"Carl Waring" wrote:

> Actually, scratch that. I mis-interpreted what I needed to do but I can't
> edit or delete the post :-( That said, it still might be useful to know ;-)
>
> This is what I need to know!
>
> If the number in [cell] is <=X then take off A%
> then
> If the number in [cell] is <=X then take off B%
> then
> If the number in [cell] is <=X then take off C%
> then
> Display result
>
>
> Thanks.
From: Jacob Skaria on
One way using IF()

=A1-(A1*IF(A1<=50,10%,IF(A1<=100,20%,IF(A1<=500,30%))))

--
Jacob


"Carl Waring" wrote:

> Actually, scratch that. I mis-interpreted what I needed to do but I can't
> edit or delete the post :-( That said, it still might be useful to know ;-)
>
> This is what I need to know!
>
> If the number in [cell] is <=X then take off A%
> then
> If the number in [cell] is <=X then take off B%
> then
> If the number in [cell] is <=X then take off C%
> then
> Display result
>
>
> Thanks.