"Error: Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 4 arguments."
I'm getting that error for this formula:
=IF(B3=1,B46,IF(B3=2,C46,IF(B3=3,D46,IF(B3=4,E46,IF(B3=5,F46,IF(B3=6,G46,IF(B3=7,H46,IF(B3=8,I46,IF(B3=9,J46,IF(B3=10,K46,IF(B3=11,L46,IF(B3=12,M46),("ERROR"))))))))))))
How can i re-write this to work?
Thank you in advance!
How about this?
=IFERROR(INDEX($B$46:$L$46,,B1), "ERROR")
If posting code please use code tags, see here.
Try =IF(AND($B$3>=1,$B$3<=12),INDEX($B$46:$M$46,1,B3),"ERROR")
you were given two good answers but just an FYI the problem in your formula is here IF(B3=12,M46),("ERROR"))))))))))))
it should look like this... previous part of formula then IF(B3=12,M46,"ERROR"))))))))))))
if you try to use a nested IF / THEN formula in the future.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks