Need help with If function

[HVK1986]

Dear Sir Hui, pls suggest me a formula for the below mentioned data.

if in cell A1 the amount is <25 then in B1 it should display "not eligible", if amount in cell A2 is >=25 and <50 in cell B1 it should come as 50, likewise >=50 but <100 it should come as 60, and >100 it should come as 75.


Pls suggest a formula

 

[Hui]

You seem to be mixing A1 and A2 but the basic layout is:

=if(A1<25,"not eligible",if(and(a2>=25,a2<50),50,if(and(a2>=50,a2<100),60,100)))

 

[Hui]

HVK1986


Please also use appropriate titles for Posts like

"Need help with If function"


What if I was on 2 weeks holidays?

 

[HVK1986]

Sir thank u very much.

job done

 

[HVK1986]

ok sir.