@cheatsheets: Switch in Excel‼️ #excel #exceltips #exceltricks #exceltutorial

CheatSheets
CheatSheets
Open In TikTok:
Region: US
Tuesday 09 January 2024 14:00:05 GMT
200078
5430
26
453

Music

Download

Comments

eldestdad
Eldest Dad :
I’d use a secondary table on another table and then vlookup (use true function) in case you need to update the values or you have more than 3
2024-01-09 14:52:07
39
bala__azul
Bala__Azul :
those names 🤣
2024-01-09 14:34:36
11
max.achusetts
Max :
I think this is a scenario that a lookup table would be far more efficient
2024-01-11 05:25:02
4
azubuikeobinna6
Obividic :
What if those numbers are letters, will the same formula apply?
2024-01-11 18:37:23
1
la_guerita_conojosazules
la_guerita_conojosazules :
THE NAMES BRO
2024-01-11 00:09:06
1
aut0botsrollut
waynezhang :
Or, Data->validation->list
2024-03-09 00:48:33
0
osman_bakar75
Osman Bakar :
why was Ben Dover fired?
2024-02-17 04:58:36
0
ovisky9
Ovie :
=If(
2024-02-08 07:52:56
0
baron_saamedi
Baron_saamedi :
if function stopped working?😳
2024-02-07 05:23:28
0
elissa9h
elissa :
how can make report
2024-01-30 08:47:06
0
trustykogah
Trusty :
what about nested if?
2024-01-20 05:50:32
0
kingkhanmallu
user8878993027481 :
this excel which one i dont get thisbone 🥲
2024-01-18 08:11:56
0
kennethwalker76
Kenneth Walker :
If your name is Snotball, I'd be firing you too 🤷‍♂️
2024-01-17 02:26:27
0
ranahammadiqbal
Rana Hammad Iqbal :
where is if farmula 😂😂😂
2024-01-15 09:25:05
0
userpk55zcatfchdsyjkk
أبو :
Why not using IFS function?
2024-01-13 16:42:12
0
oxrchl
Grenade Jumper :
is there a way to do this with times? like =switch(c3,1:00-2:00,”1pm-2pm”) or is there a different way to grab times and put them in buckets? 🤔
2024-01-12 20:39:25
0
bm2015_
Nitrazepam :
poor Al Coholic 😂
2024-01-12 13:49:40
0
pewtercitygymldr
PewterCityGymLdr :
Wouldn’t Ifs work just the same?
2024-01-10 01:13:29
0
To see more videos from user @cheatsheets, please go to the Tikwm homepage.

Other Videos


About