I think I need a multiple IF statement, or is there another way?

  • Thread starter Thread starter Carl Waring
  • Start date Start date
C

Carl Waring

I can do the simple stuff, but this is more complicated!

In English, this is what I want to do

If the number in [cell] is <=X then take off %
then
If the number in [cell] is <=Y then take off a further %
then
If the number in [cell] is <=Z then take off a further %
then
Display result

It's probably as nested IF statement, but I don't know how to construct it.

Thanks.
 
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.
 
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.
Click to expand...

I'm not sure you've stated it correctly, but something like:

=if(cell<=x,(1-a-b-c)*x,x)

--ron
 
Back
Top