=IF(OR(C224="Kitchen Assistant","Kitchen Chef"),"0",IF(OR(C224="contact Centre","Contact centre 2"),IF(T224>=9,10,IF(T224=8,7.5,IF(T224=7,2.5,"0"))),IF(T224>=9,5,IF(T224=8,3.75,IF(T224=7,1.25,"0")))))
Hello,
Im trying to get the above statement to work, however it wont.
Below is what its started as but then i wanted to add in a OR stament as above so that i can have the inital checks for 2 critira instead of making a huge mess of a formula.
=IF(C226="Kitchen Assistant","0",IF(C226="contact Centre",IF(T226>=9,10,IF(T226=8,7.5,IF(T226=7,2.5,"0"))),IF(T226>=9,5,IF(T226=8,3.75,IF(T226=7,1.25,"0")))))
I hope this is explained well enough let me know if i can provide any more information
Bookmarks