If A1 value is between 100 and 200 then text in A3...

[excy]

Hi everybody,

id like to have the formula in case a value in A1 is between 100 and 200 then text in A3 is 10%, if the value in A1 is between 201 and 300 then the text in A3 is 20%.
Thanks for your help

[Kaper]

to answer exactly the question in A3:

Please Login or Register  to view this content.

[tchock]

=IF(AND(A1>100,A1<=200),10%,IF(AND(A1>200,A1<=300),20%,""))

you can change to >=, if necessary, and replace the "" with the value you want to be filled, in case the conditions are not met.

[excy]

Thanks everybody i solved i dont know where to put solved anyway ill leave my feedback