IF(AND OR function

[pujoflo]

Hi all,

My first post here!!!

I want to compare a value in pecentage format and it just does not seem to work... it looks like this;
if the value in cell is equal or greater than 103% and smaller than 104% multply by 2

Please help!

[jjhayes]

Assuming your inputs start in cell A1, does this formula in B1 work?

Please Login or Register  to view this content.

You didn't say what you wanted to do when the input is not between 103% and 104%, so in that case, this will return the original input.

[JohnTopley]

try

=IF(AND(A1>=1.03,A1<1.04),B1*2,B1)

100% =1

[Special-K]

Assuming your inputs start in cell A1, does this formula in B1 work?

Please Login or Register  to view this content.

You didn't say what you wanted to do when the input is not between 103% and 104%, so in that case, this will return the original input.

I think jjhayes means A1 not A2

UPDATE: Ah, he spotted his mistake! :-)

[jjhayes]

Special-K...

Thanks...you are right...typo.