More IF/OR formula help needed.

[mplees]

Hi,

Wonder if anyone can help me with this. I need a formula who's result comes from evaluating another cell.

The evaluated data will be in column F, the result in column M. What I need to evaluate is as follows:

If F1=1,2,3, 8 or 10 then 0
If F1=7 then 25
If F1=4 or 9 then 50
If F1=5 then 75
if F1=6 then 100

can anyone steer me in the right direction?

Regards,

Mark

 

[MarkAndrews]

You could reference your IF statement to multiple cells, which contain IF's

Thats what i usually do when i need more than 7 IF's

 

[Jonmo1]

=IF(F1=7,25,If(OR(F1=4,F1=9),50,If(F1=5,75,If(F1=6,100,0))))

This is presuming that F1 will not be greater than 10 or less than 1...

If that's not the case, one more If is needed...

=IF(OR(F1=1,F1=2,F1=3,F1=8,F1=10),0,IF(F1=7,25,IF(OR(F1=4,F1=9),50,IF(F1=5,75,IF(F1=6,100,"Less than 1 or Greater than 10")))))

 

[Domski]

Hi,

Like this maybe:

Book4
	A	B	C	D	E	F	G
1	1	0				4	50
2	2	0
3	3	0
4	4	50
5	5	75
6	6	100
7	7	25
8	8	0
9	9	50
10	10	0
Sheet1

Dom

 

[Darren Bartrup]

Not sure if this is the best solution, but it works

=CHOOSE($F$1,0,0,0,50,75,100,25,0,50,0)

 

[mplees]

Gentlemen,

Thank you all so much for your input - problem solved, and as always a great learning experience.

Thank you all again,

Mark