# 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.

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?

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

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

=MEDIAN(A3,B3,C3)

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1