Hey All!
I am trying to input the below formula and it worked fine until I added in the bolded section which now brings up the error "You've entered too many arguments for this function."
This is the formula...
=+IF(A2="NSW",K2&".20",IF(A2="QLD",K2&".40",IF(A2="VIC",K2&".30",IF(A2="WA",K2&".50",K2&".00",IF(A2="ACT",K2&".21")))))
Can anyone help with this and why its no longer working? How can I possibly shorten it?
Thanks
Jamie![]()
Bookmarks