thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 954
- Office Version
- 365
- Platform
- Windows
Hi all,
I am having a difficult time combining these 4 individual statements. Can anyone help?
=IF(E5<21,Helper!U2)
=IF(AND(e5>20,e5<51),Helper!v2,"")
=IF(AND(e5>50,e5<101),Helper!w2,"")
=IF(e5>100,Helper!x2)
Many thanks in advance!
I am having a difficult time combining these 4 individual statements. Can anyone help?
=IF(E5<21,Helper!U2)
=IF(AND(e5>20,e5<51),Helper!v2,"")
=IF(AND(e5>50,e5<101),Helper!w2,"")
=IF(e5>100,Helper!x2)
Many thanks in advance!