Just FYI, here is how it would look with an IF function:
=IF(A1>1000000,"large",IF(A1>=100000,"Medium",IF(A1< 100000,"small")))
which can be shortened to
=IF(A1>1000000,"large",IF(A1>=100000,"Medium","small"))
Just FYI, here is how it would look with an IF function:
=IF(A1>1000000,"large",IF(A1>=100000,"Medium",IF(A1< 100000,"small")))
which can be shortened to
=IF(A1>1000000,"large",IF(A1>=100000,"Medium","small"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks