look at column  A and made a determination based on the value and place a word in Col  B.

ssblue
ssblue used Ask the Experts™
on
Excel - I need to look at column  A and made a determination based on the value and place a word in Col  B.
If   A2  is less than  673  put "Short" in Col  B2
If   A2  is between  674 and 2016  put  "Mid"  in Col  B2
If   A2  is greater than  2017  put  "Long"  in Col  B2
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Maybe this...

=IF(A2="","",IF(A2>=2017,"Long",IF(A2<=673,"Short","Mid")))

Open in new window

ssblueCoordinator

Author

Commented:
That made everything "Long"
ssblueCoordinator

Author

Commented:
Sorry I changed a column but I fixed it and it works great!!  Thanks
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
What is in A2?
Can you post a small sample file?

Here is how it works on my end.
IFFormula.jpg
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Great! Glad it worked as desired in the end.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial