# If statement with a range.

1. ## If statement with a range.

Hello everyone,

I am very very new to using excel and I need help with ranges.
For example:

I have numbers A, B, C in cells A3,B3,C3 respectively.

If number B is less than A it should show the number from A3 in the answer field
If number B is between the A & C then B3 is in the answer field
If number B is larger than C then C3 is in the answer field.

I know this should be simple, but for the life of me everything I have tried it has said to many arguments or whatever.

Thanks in advance for any help.  Register To Reply

2. ## Re: If statement with a range.

=if(B3>C3,C3, if(B3<A3,A3,B3))

This assumes the number is A is always less than the number in C?  Register To Reply

3. ## Re: If statement with a range.

I also assume C3 > A3 in which case you can use

=MEDIAN(A3,B3,C3)  Register To Reply

4. ## Re: If statement with a range.

Thank you both, using the median function never even crossed my mind. This might actually be better for what I had in mind. again thank you so much  Register To Reply