# If Function Solution in Excel

IF Function Question
“Excel ‘if’ question? What formula? I’m wondering what formula I would need to use on Microsoft excel. Basically depending on the size of a room, it would be S (small), M (Medium) or L (Large).
Less then 6.5m = S
6.5 to 11.5m = M
11.5 or larger = L
What formula would I need to enter in order for Excel to automatically decide if the size of the room is S, M or L?
Thanks”

Solution:
Using the IF Function
=IF(A2<6.5, “S”, IF(A2<11.5, “M”, “L”)) Or
=IF(A2<6.5,”S”,IF(A2<11.5,”M”,”L”))

Using the Lookup Function
=IF(A2=””,””, LOOKUP(A2,{0,6.5,11.5;”S”,”M”,”L”}))
In the lookup formula the first part checks whether the cell A2 has any data at all and then proceeds further.

Using Vlookup (most versatile)
=Vlookup(A2, mydata, 2)
‘mydata’ is the named range.

Watch the MS-Excel training video below to see how the solution is found using IF, lookup and vlookup functions.

This site uses Akismet to reduce spam. Learn how your comment data is processed.