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