Baby stuff I know-if

J

Joe

HI, Which formula I need to write So when the cell in A1 is >0 but <1 then
give me 1; but if >1 then give me the number

thanks
 
S

Stephen

Joe said:
HI, Which formula I need to write So when the cell in A1 is >0 but <1 then
give me 1; but if >1 then give me the number

thanks
Click to expand...

What if A1<=0?
What if A1=1?

maybe this will do?
=MAX(A1,1)
 
J

Joe

it has to be as follows:

eg A1 = 0.5, A2=1.3, A3=0

So, If >0 but less than 1 I want to have 1 but If it is higher than 1 and
want to the number

So
For A1 I would have 1
For A2 I would have 1.3
For A3 I would have 0

Regards,
jose
 
R

Rick Rothstein \(MVP - VB\)

Just use Stephen's formula as he posted it. Put this...

=MAX(A1,1)

in B1 and then copy it down. It will return 1 when A1 is less than 1 and the
number in A1 if that number is greater than (or equal to) 1.

Rick
 
D

David Biddulph

You still haven't told us what you want if the input is less than 0.

If you want the input value to be used as the output in that case, then
=IF(AND(A1>0,A1<1),1,A1)
 
J

Joe

Thanks to all for the help. It really works.

How does it work? I mean. What does the AND do? So I understand the logic :)
 
P

PaulW

an IF statement works by saying (Statement, Result if True, Result if False)

What the AND lets you do is include two statements, so both have to be true.
I find its sometimes helpful to go through the Formula Evalutation in the
tools menu
 
Top