Ok, One more formula please......

[Utradeshow]

Can cell C1 perform this function???

Book1
	A	B	C	D
1
2
3	IfA1=1-600andB1=1or3thenC1=77%
4	IfA1is601>andB1=1or3thenC1=68.8%
5	IfB=2thenC1=0%
Sheet1

 

[Jonmo1]

=IF(AND(A1<=600,OR(B1=1,B1=3)),0.77,IF(AND(A1>600,OR(B1=1,B1=3)),0.688,IF(B1=2,0)))

 

[SteveO59L]

Solutions are similar to the replies to your post, here


http://www.mrexcel.com/board2/viewtopic.php?t=284823

 

[Utradeshow]

Yes they are similar, I am aweekend warrior in the excel world and sometimes I can manipulate a formula to be tailored to my need.. But that one had too many changes... sorry

 

[Utradeshow]

=IF(AND(A1<=600,OR(B1=1,B1=3)),0.77,IF(AND(A1>600,OR(B1=1,B1=3)),0.688,IF(B1=2,0)))

Thank you... that is a beautiful thing.....