Hi all,
Really simple one today, I need to know how to put 3 If statements in one formula
I have to use:
=IF(U:U="Supplier1",100,0)
=IF(U:U="Supplier2",125,0)
=IF(U:U="Supplier3",150,0)
All 3 work seperately, but i need them in one cell, please help!
Really simple one today, I need to know how to put 3 If statements in one formula
I have to use:
=IF(U:U="Supplier1",100,0)
=IF(U:U="Supplier2",125,0)
=IF(U:U="Supplier3",150,0)
All 3 work seperately, but i need them in one cell, please help!