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

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.
 
C

Carl Waring

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.
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement to long, an easier way? 3
Array function - I think! 8
IF STATEMENT 19
Logical formatting for multiple values 1
If Statement for a date 3
IF value in Y cell = X color Z cell 1
nested if based on nested if in seperate sheet. how? 5
IF - AND - OR statement? 3

Top