Multiple IF formula

This worked perfectly, I had the brackets in all the wrong places to start with. Thanks v much!!

Originally Posted by bonny24tycoon

Hi Try this,

=IF(A1="Employee1","Return Rate1",IF(A1="Employee2","Return Rate2",IF(A1="Employee3","return rate3","No Value in A1")))

You can keep adding if there are multiple employees in the above formula.

Thanks,

Bonny Tycoon



**If I was able to help please click the small star icon at the bottom left of my post **