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.