HuskyJones
New Member
- Joined
- Sep 30, 2015
- Messages
- 45
- Office Version
- 365
- Platform
- Windows
Hi fabulous folk
Can you help me with this one.
I need H2 (and i'll drag it down) to choose the package name in A according to the calls in G.
I've got it working no problem for the <10 calls =IFS(G2<10,A13) but can't work out >9 or < 19 etc (i always struggle with <= so choose < next number lol)
I think it might be an IFS(AND but brain is really struggling
Many thanks hive!
(365 enterprise if that makes difference)
Can you help me with this one.
I need H2 (and i'll drag it down) to choose the package name in A according to the calls in G.
I've got it working no problem for the <10 calls =IFS(G2<10,A13) but can't work out >9 or < 19 etc (i always struggle with <= so choose < next number lol)
I think it might be an IFS(AND but brain is really struggling
Many thanks hive!
(365 enterprise if that makes difference)