@excelwithtimothy: STOP nesting IF functions in Excel if you have multiple conditions, use SWITCH instead, it's much more intuitive. The only downside is that it works only with exact matches, so for example: A1=A. It doesn't work with range-based logic like: A1<50 or A1>75 ecc... #excel #exceltips #exceltricks #excelpro #excelfunctions
SWITCH only works for values that are “equal to”. “Larger or smaller than” still requires IFS. But in this case an XLOOKUP is the best solution anyways.
2025-08-28 06:46:28
128
user71648394 :
why not just do a lookup
2025-08-29 04:52:02
18
Ali :
shortcut
2025-11-19 10:37:05
1
v :
shortcut
2025-11-18 10:21:31
1
𝓒𝓸𝓷𝓲𝓫𝓻𝓲🕊️ :
shortcut
2025-11-17 20:59:05
1
hype_casper2 :
shortcut
2025-11-20 21:23:13
1
Tari :
Shortcut
2026-03-14 18:03:45
1
Philip Githae :
shortcut
2025-10-19 07:41:10
1
Nice boi♠️ :
shortcut
2025-10-16 17:41:51
1
AlienR :
shortcut
2025-10-19 05:10:53
1
@akarodes :
shortcuts
2025-10-18 05:56:58
1
AGRIBUTEC BILLINGTON COLLEGE :
shortcut
2025-10-20 09:25:51
1
irene pecku :
shortcut
2025-10-19 14:58:45
1
vrs julius editor :
shortcut
2025-10-19 04:58:06
1
chamon1234 :
Shortcut
2026-04-13 20:21:54
1
ZAIV :
shortcut
2026-04-13 15:54:34
1
felixjohn1206 :
Shortcut
2026-02-04 01:57:30
1
emson :
shortcut
2026-04-14 00:54:41
1
BLAIZ :
shortcut
2025-10-21 01:51:27
1
Rizalyn B. :
Shortcut
2026-03-06 06:33:03
1
Thomas Mugumya :
shortcut
2025-11-21 14:01:49
1
ALD²¹³ :
shortcut
2025-12-12 18:52:30
1
Bẻo Bẻo nè :
Shortcut
2025-10-17 03:05:03
1
user9874709267140 :
Shortcut
2026-03-08 19:40:56
1
xaidis :
shortcut
2025-10-18 10:10:45
1
To see more videos from user @excelwithtimothy, please go to the Tikwm
homepage.